Calculated date not doing anything

Question

I have made a library containing a list of files that need to be reviewed every 3 years. I have a Date Created column, a ReviewPeriod column in number format set to 3, and a Review Date column as a calculated column that adds the review period to the creation date.

The formula for the calculated Review Date is:

=DATE(YEAR([Date Created]+ReviewPeriod),MONTH([Date Created]),DAY([Date Created]))

The output type is set to Date & Time > Date Only. However, the resultant Review Date column is just showing the exact same date as the Creation Date.

Answer 1

Dear LA8887,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, it seems that you are trying to create a calculated column in SharePoint list that add the ReviewPeriod to the DateCreated.

If the understanding above is right, we've done a quick test on our side by creating ReviewPeriod as a Number column, the formula works as expected on our side, as shown below:

=DATE(YEAR(DateCreated)+ReviewPeriod,MONTH(DateCreated),DAY(DateCreated))

Meanwhile, please also check if the formula shared below can help:

=DateCreated+(ReviewPeriod*365)

Using Date and Time:

Using Date Only:

If the understanding above is not consistent with yours, please feel free to post back and point that.

Your understanding and patience will be highly appreciated. We hope that you are keeping safe and well!

Thanks for your cooperation.

Sincerely，

Rhoda | Microsoft Community Moderator

[Updated by Rhoda Zhong, 20:49 P.M., UTC+8, 7/31/2023]