Formula for 1st of month following 30 days

  • Thread starter Thread starter lawson99
  • Start date Start date
L

lawson99

I am trying to write a formula to show the 1st of the month folliwng 3
days. Can anyone help me with this formula
 
I'm not entirely sure what you're looking for, but perhaps the following
formula is what you want.

=DATE(YEAR(A1+30),MONTH(A1+30),1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trailing 30 days sum calculation with excel 1
Excel Message box with days of month & date. 1
formula to return 1st of the month following 60 days 3
Last working day of a month 12
Expanding Date formula 1
Use first day of month formula in a drop down list 3
Formula IF 1
Counting formula help needed! 2

Back
Top