Home/ Questions/Q 15233
Next
Answered
computing
  • 0
Asked: 2021-12-18T22:35:02+00:00 In:

Excel – First Of Month Following 30 Days

  • 0

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

Share

    1 Answer

    1. Best Answer
      =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.

      • 0