Problem: I have a list and each time the list item is approved, I need to add 180 days to the expiry date.
Initial Hypothesis: Create a Date and Time site column in the list. Edit the "Calculated Value" box with a formula that will add 180 days to the current date.
Resolution: The formula to move the expiry date 180 days from the current date is:
=DATE(YEAR(Today),MONTH(Today),DAY(Today)+180)
Initial Hypothesis: Create a Date and Time site column in the list. Edit the "Calculated Value" box with a formula that will add 180 days to the current date.
Resolution: The formula to move the expiry date 180 days from the current date is:
=DATE(YEAR(Today),MONTH(Today),DAY(Today)+180)
No comments:
Post a Comment