Formula for 1st of month following 30 days

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
 
C

Chip Pearson

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
 
J

Jim

I do not understand your needs exactly, but you could try this:
=EOMONTH(TODAY()+30,0)+1
 
Top