Remember Me?

#1
December 30th 09, 08:21 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 683
First Day of Next Quarter

Hi, how would one create a cell formula to return the first day of the next
quarter?

#2
December 30th 09, 08:32 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 11,501
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?

#3
December 30th 09, 09:33 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Feb 2007 Posts: 8,651
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?

#4
December 30th 09, 11:30 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 7,247
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?

#5
December 31st 09, 03:14 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jun 2007 Posts: 806
First Day of Next Quarter

=DATE(YEAR(A1),1+FLOOR(MONTH(A1)+2,3),1)

Regards,
Bernd

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post bklex New Users to Excel 2 September 13th 12 03:34 PM Kent Prokopy[_2_] Excel Worksheet Functions 4 March 24th 09 01:47 PM Gerard Excel Discussion (Misc queries) 8 June 25th 08 05:02 PM LR Excel Worksheet Functions 8 October 31st 06 10:27 AM Wolfspaw Excel Worksheet Functions 6 March 4th 06 02:10 AM

All times are GMT +1. The time now is 01:38 AM.