Date Formula Problem

See attached.    I am having problems with the date  date formula.   I add 12 months to the moths and the year does not change.  

 

The formula is set up to add # of months(MONTHS) to the start date (SDATE) to calculate and populate  the end date (EDATE).  It seems the formula works so long as the start date and end date are in the same year.   Most of my calculation will include two or more years.

 

 

45.JPG

200_0.JPG

201.JPG

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!