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
Help Article Resources
Check out the Formula Handbook template!