Excel - first of month following 30 days

September 21, 2011 at 07:38:50
Specs: Windows 7
I am trying to create a formula to take a date, add 30 days and then round to the first of the following month.

Ex: Date 9/10/11 add 30 days and then display the first of the following month
Result: : November 1, 2011


See More: Excel - first of month following 30 days

Report •


#1
September 22, 2011 at 20:51:42
=DATE(YEAR(A1+30),MONTH(A1+30)+1,1)

Lots of Date and Time functions can be found here:

http://www.cpearson.com/excel/DateT...

I modified the Last Day Of Month formula to get to your solution.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question