Friday, September 14, 2012

Adding Months To A Date In Excel

=IF(DAY(DateReference) > DAY(DATE(YEAR(DateReference),MONTH(DateReference)+MonthsToAdd+1,1)-1),DATE(YEAR(DateReference),MONTH(DateReference)+MonthsToAdd+1,1)-1,DATE(YEAR(DateReference),MONTH(DateReference)+MonthsToAdd,DAY(DateReference)))
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)