Formula for Expiry Date + 36 months

Sherill

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!

Nick Korna

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!

Nick Korna

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!

Sherill

Duh...thanks for you quick response!