How do you create a calculated field that takes the date that a project is completed and add 1 year to that date.

[sljonas]

I'd like to add a calculated expression in my form called "Expiration Date". Calculation is based on the project "Actual Completion Date + 1 year. So if the project was completed on 8/15/2020, The field "Expiration Date" would display 8/15/2021.

[sljonas · Accepted solution]

I figured it out, I was using camel case in my formula

ADDYEARS(actualCompletionDate, 1) should have been ADDYEARS(Actual Completion Date, 1)

[kynabaker16]

Thank you for sharing your answer! If you had the question, I guarantee you that someone else did too! So glad you got it figured out.