Forum Discussion

RLUGO's avatar
RLUGO
Copper Contributor
Aug 29, 2022

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!

  • 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's avatar
    RobElliott
    Silver Contributor

    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's avatar
      RLUGO
      Copper Contributor

      Hi RobElliott

       

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

       

       

       Thank you!

      • RobElliott's avatar
        RobElliott
        Silver Contributor

        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)

         

         

Resources