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.
