Friday 6 September 2013

Excel - Add a Month

I use MS Excel extensively in my day to day role.  Sometimes the simplest formula can stump me, but when I find a solution, I try to capture it and add it to this blog.

This formula will take a date (say 1st Oct 2013) and then add one month to it.

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

Simple.