SOLVED

# Using a Calculated Value for a Date/Time Column in SP List

Copper Contributor

# 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 "Date of Recognition" (date/time column in same list)

This is what I have tried:

=DATE(YEAR([Column4]),MONTH([Column4])+[Column10],DAY([Column4]))

Where:

- Column 4 = Date of Recognition

- Column 10 = Months Available (default value = 3)

Any help is greatly appreciated!

6 Replies
best response confirmed by RLUGO (Copper Contributor)
Solution

# Re: Using a Calculated Value for a Date/Time Column in SP List

@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)

# Re: Using a Calculated Value for a Date/Time Column in SP List

Hi @RobElliott

This is the error message I receive when attempting to enter the formula.

Thank you!

# Re: Using a Calculated Value for a Date/Time Column in SP List

@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)

# Re: Using a Calculated Value for a Date/Time Column in SP List

I understand now. Thank you for your help!

# Re: Using a Calculated Value for a Date/Time Column in SP List

Similar threadFormula does not work for SharePoint/Lists

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

# Re: Using a Calculated Value for a Date/Time Column in SP List

@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?