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.