First Day of Next Quarter

M

Mike H

Brian,

Try this

=EOMONTH(TODAY(),MOD(MONTH(TODAY())*2,3))+1

If your using E2003 and get a NAME error then

Tools|Addins and select the analysis toolpak and re-enter the formula

Mike
 
C

Chip Pearson

Another way....


=DATE(YEAR(A1)+(MONTH(A1)>9),CHOOSE(MONTH(A1),4,4,4,7,7,7,10,10,10,1,1,1),1)

where the date is in cell A1. Change "A1" to "TODAY()" if you always
want to use the current date.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
 

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

Conditional Formatting End of Quarter 7
how to carry forward a total from one page to another 3
1st of current quater today() 5
formula for first saturday of quarter 13
How to determine the date? 2
Partial Eclipse 2
First Date of Next Quarter 3
Auto format quarter start date 2

Top