Date formula in SharePoint calculated value

Advertisement
In this article I want to show you to get the next 3 years date based on the today’s date, without using Script we can do it simply using the Calculated Value.

We are having a list with name “Date” with Column “Next3Years” and created the calculated value as shown below with settings.

=DATE(YEAR(Today)+3,MONTH(Today),DAY(Today))


We also change X years instead of 3 years based on your requirement.
While Creating new item we can able to see the column as shown below, if we want to change the date we can able to change and save the  item without any issues.
Finally it looks as shown below.




SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM
Advertisements
SHARE

Lakshmi Tulasi Jasti

  • Image
  • Image
  • Image
  • Image
  • Image
    Blogger Comment
    Facebook Comment

0 comments:

Post a comment