Formula for Expiry Date + 36 months
Not real savvy with formulas so apologize in advance if this is pretty basic. I need a formula to calculate an expiration date based on an "Award Date" + 36 months. I don't currently have a "helper" column to designate 36 months but can add if needed. Also, Award Date and Expiry dates are set as a date column. Thanks for your help!
Best Answer
-
Hi @Sherill,
The below formula is a short one to enter in Expiry date:
=[Award Date]@row+1095
36 months = 3 years = 3*365=1095
Hope this helps!
Answers
-
Hi @Sherill,
The below formula is a short one to enter in Expiry date:
=[Award Date]@row+1095
36 months = 3 years = 3*365=1095
Hope this helps!
-
Duh...thanks for you quick response!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
