Formula in SharePoint list

And also make sure that you need to choose Number in the The data type returned from this formula is: section for the calculated column. It will look like below:

After this based on the status column in the list, the color will come like below:

This is how to color-code SharePoint list column value based on condition using the calculated column in SharePoint.

3. SharePoint calculated column concatenate

This is an interesting example of SharePoint calculated column concatenate. Here, we will see, how to concatenate two columns in SharePoint list using a calculated column.

Let us see, how to concatenate two list columns in SharePoint 2013 using the SharePoint calculated column.

Here in this example, I have a SharePoint list that has two columns name column1 and column2. And we are concatenating these two columns and displaying the result in a 3rd column using the calculated column in SharePoint 2013/2016/Online.

Here first two columns in the SharePoint list and then create another column of type calculated column. And add the formula like below:

You can check out the formula how it looks like:

Now if you add an item to the SharePoint list then the concatenate value will appear in the 3rd column like below:

This is how to use CONCATENATE function in SharePoint list calculated column to concatenate multiple columns in SharePoint 2013/2016/Online List. This is how we can use sharepoint concatenate in a calculated column.

4. SharePoint calculated column year from date

Let us see another example of how to get month and year from date in sharepoint calculated column? We will see, how to get year from date using SharePoint calculated column.

I will explain SharePoint calculated column get month and year from the date in SharePoint 2013/2016/Online. We will discuss how to extract Year and Month from the created date column in SharePoint 2013/2016. Here we will extract through a calculated column and store it in two separate columns in the SharePoint Online list.

SharePoint 2013: Calculated column to get month and year from date

Here I have created few calculated columns in the SharePoint list and I will show you how to retrieve year and month from created date column.

Go to the SharePoint list settings and then click on Create column to add a new column. Give the column name and chose the column type as a calculated column. Then in the formula write like below:

=TEXT[[Created],yyyy]

The SharePoint calculated list columns looks like below:

The above formula will return the formula as a single line text, Now if you want to return as integer then you can write the formula like below:

=YEAR[Created]

Similarly if you want to calculate month from created date, then follow the above step and write the formula like below:

=Text[Created, MMMM]: This will return the full month name
=Text[Created, MMM]: This will return first 3 letters of the month name
=Text[Created, MM]: This will return integer month

If you want to return the value as an integer then you can write the formula like below:
=MONTH[Created]

Now if you will check the output will come like below:

This is how to get month and year from date in sharepoint calculated column. I hope you like an example on SharePoint calculated column year from date.

Here, we saw, how to use sharepoint calculated column get month and year from created date column in SharePoint 2013/2016/2019/Online.

5. SharePoint calculated column difference between two dates

Let us see another example on SharePoint calculated column difference between two dates.

Recently, I was working on Project where There was a requirement to display the duration in Hour and Minute between two dates in SharePoint. In this article, I am going to explain how to retrieve the difference between two dates in hour and minute by using a calculated column in SharePoint 2013.

Follow the below steps:
Step-1: Create a SharePoint List having two columns of Date and Time Type as below:

Step-2: Now create a Lookup column BookedDuration[This Column will automatically calculate duration between the above Column].

The Result will be Shown as below:

This is how to calculate the duration between two dates in SharePoint List using the SharePoint calculated column.

You may like the following SharePoint tutorials:

• SPFx Bind dropdown list from SharePoint list using PnP
• SharePoint list templates
• Display SharePoint list data in jQuery data table using Rest API
• Difference between SharePoint list and Document library
• Export a SharePoint list to excel
• Convert SharePoint list item to PDF using Flow or Power Automate

In this SharePoint tutorial, we learned about, SharePoint calculated column and 5 examples of how to use calculated column in SharePoint list or document library.

• What is a calculated column in SharePoint?
• How to create a calculated column in SharePoint List
• SharePoint Calculated Column Examples
• Create hyperlink in SharePoint calculated column
• SharePoint list column color based on value using calculated column
• SharePoint calculated column concatenate
• SharePoint calculated column year from date
• SharePoint calculated column difference between two dates