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)
RobElliott I'm looking to do something similar but I would like to create a reminder 1 week before the three months+ date. If i make it a calculated column though it doesn't show up as an option when I try to set the reminder in Automate. Anyway I can do it in a date column?
