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
0 comments:
Post a Comment