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
 
With tha date in A1,
=("1-"&MONTH(A1+30))*1
and format as a date,
Regards,
Alan.
 
I do not understand your needs exactly, but you could try this:
=EOMONTH(TODAY()+30,0)+1
 
You must log in or register to reply here.

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
Use first day of month formula in a drop down list 3
Expanding Date formula 1
Formula IF 1
Counting formula help needed! 2

Back
Top