First Day of Next Quarter
Hi, how would one create a cell formula to return the first day of the next
quarter? |
First Day of Next Quarter
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 "Brian" wrote: Hi, how would one create a cell formula to return the first day of the next quarter? |
First Day of Next Quarter
.... or =DATE(YEAR(A1),MONTH(A1)+3-MOD(MONTH(A1)+2,3),1) if you don't want to
bother with the ATP. -- David Biddulph Mike H wrote: 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 "Brian" wrote: Hi, how would one create a cell formula to return the first day of the next quarter? |
First Day of Next Quarter
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] On Wed, 30 Dec 2009 12:21:02 -0800, Brian wrote: Hi, how would one create a cell formula to return the first day of the next quarter? |
First Day of Next Quarter
=DATE(YEAR(A1),1+FLOOR(MONTH(A1)+2,3),1)
Regards, Bernd |
All times are GMT +1. The time now is 02:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com