Forum Discussion
Solved
Using a Calculated Value for a Date/Time Column in SP List
Hello SP Community, I'm trying to create a date/time column in a SP list using a calculated value. I would like to create an "Expiration Date" column (calculated value) by adding 3 months to "Dat...
RLUGO I can't see anything wrong with your formula; this worked for me:
=DATE(YEAR([Insurance Expiry Date]),MONTH([Insurance Expiry Date])+Months,DAY([Insurance Expiry Date]))So what result are you getting?
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
RLUGO I can't see anything wrong with your formula; this worked for me:
=DATE(YEAR([Insurance Expiry Date]),MONTH([Insurance Expiry Date])+Months,DAY([Insurance Expiry Date]))
So what result are you getting?
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
RobElliott This won't seem to work if the additional months make it greater than 12 though.