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 no, it needs to be a calculated column. It won't work in the way you have done it with a date/time column.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
I understand now. Thank you for your help!