Formula to generate the expiration date, 1 year after date signed?


I am trying to figure out a formula that can generate the "expiration" date based on the "date last signed". The "expiration" date is one year from "date last signed". Note, dependencies are off.

Example: If the "Date Last Signed" is 01/01/20 then the "Expiration" date should be 01/01/21. Seems pretty straight forward but cannot figure it out. Please help?!

Thank you, Justine


Best Answer


  • Justine Guido

    It worked! Thank you so much!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!