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)
