SharePoint calculated column get month from date

This tutorial is all about examples related to “SharePoint calculated column get month from date.”

I will show you how to create a calculated column to get the month name from a date column in a SharePoint list and how to create a calculated column to get month number (07 for July) from a date column in the SharePoint online list.

Moreover, I will explain how to create a calculated column to get the year from a date in the SharePoint list. And also, I will cover how to create a calculated column to get the month and year from the date in the SharePoint online list.

For example, I have a SharePoint Online list with a Product Supplied Date column (Date and time). Based on that column, I will create a calculated column to get a month name, month number, and year and a month and year from the date column.

SharePoint calculated column get the month name from a date column

Based on my SharePoint list, I will show how to create a calculated column to get the month name from the date.

• If the date is 11/8/2022, it provides November month using the SharePoint calculated column.

To achieve this, follow the below steps:

• Open your SharePoint List, where you need to show the month name.
• Click on the +Add column -> choose See all column types -> Then click on the Next button.

• In Create column page, provide the column name and choose the type as Calculated (calculation based on other columns) as shown below:

• Now provide the formula in the formula box using the TEXT statement. Based on my requirement, I provided the formula as shown below:

=TEXT([Product Supplied Date],"MMMM")

• The data type returned from this formula is: Choose the data type as a Single line of text.
• Then, click on the OK button.

• Now open your SharePoint list, the calculated column will be added as Product Supplied Month.

This is how to create a calculated column to get the month name from the date in a SharePoint list or library.

SharePoint calculated column get month from a date column

Based on my SharePoint list, I will display the month number of Product Supplied date.

• If the date is 11/8/2022, then it provides the 11th-month number (November) using SharePoint calculated column as shown below:

To achieve it, follow the below steps:

• Open your SharePoint List where you need to show the month number.
• Click on the +Add column -> choose See all column types -> Then click on the Next button.
• In Create column page, provide the column name and choose the type as Calculated (calculation based on other columns) as shown below:

• Now provide the formula in the formula box using the TEXT statement. Based on my requirement, I provided the formula as shown below:

=TEXT([Product Supplied Date],"MM")

• The data type returned from this formula is: Choose the data type as Number.
• Then, click on the OK button.

• Now open your SharePoint list, the calculated column will be added as Product Supplied Month Number.

This is how we can create a calculated column to get the month number from the date.

SharePoint calculated column get a year from date column

I will display the Year of Product Supplied date based on my SharePoint list.

• If the date is 11/8/2022, then it provides 2022 using SharePoint calculated column as shown below:

To achieve it, follow the below steps:

• Open your SharePoint List where you need to show the year.
• Click on the +Add column -> choose See all column types -> Then click on the Next button.
• In Create column page, provide the column name and choose the type as Calculated (calculation based on other columns) as shown below:

• Now provide the formula in the formula box using the TEXT statement. Based on my requirement, I provided the formula as shown below:

=TEXT([Product Supplied Date],"YYYY")

• The data type returned from this formula is: Choose the data type as Number.
• Then, click on the OK button.

• Now open your SharePoint list, the calculated column will be added as Product Supplied Year.

This is how to create a calculated column to get the year from the date in the SharePoint list.

SharePoint calculated column get month and year from date column

Based on my SharePoint list, I will display the month and year of the Product Supplied date.

• If the date is 11/8/2022, then it provides 11/2022 using SharePoint calculated column as shown below:

To achieve it, follow the below steps:

• Open your SharePoint List where you need to show the month number and year.
• Click on the +Add column -> choose See all column types -> Then click on the Next button.
• In Create column page, provide the column name and choose the type as Calculated (calculation based on other columns) as shown below:

• Now provide the formula in the formula box using the TEXT statement. Based on my requirement, I provided the formula as shown below:

=TEXT([Product Supplied Date],"MM/YYYY")

• The data type returned from this formula is: Choose the data type as a Single line of text.
• Then, click on the OK button.

• Now open your SharePoint list, the calculated column will be added as Product Supplied Month and Year.

This is how to create a calculated column to get the month and year from the date in the SharePoint list.

Conclusion

Here I have shown you all how to create a calculated column to get the month name from the date column and calculate the month number (April as 04) from the date column.

And also, I have explained how to create a calculated column to get the year from the date column and how to create a calculated column to get the month and year from the date column.

You may also like:

• SharePoint calculated column: difference between two dates
• SharePoint list calendar view formatting
• SharePoint calculated column random number