B Brian Dec 30, 2009 #1 Hi, how would one create a cell formula to return the first day of the next quarter?
M Mike H Dec 30, 2009 #2 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, 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 Dec 30, 2009 #3 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]
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]
