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.

1 comment:

  1. Thank you for providing visitors like me different opinions to consider. The details you provide on this website has assisted me significantly.

    Jiaxing Almetal Cable Wires Co.,Ltd.

    ReplyDelete