Add Months (EDATE)

This is an alternative to EDATE if you don't have the Analysis Toolpak installed.


B1 = Months to add

This formula avoids problems with different numbers of days in a month. It will either return the same day in the month added by B1, or it will calculate to the end of that month. (No overlapping into the month immediately after)

I also saw this formula posted on a forum. It works in a simliar way to my formula above.


© Copyright All Rights Reserved.