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

=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.

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History