Even better, I had a mindset of 13*7 but 91 will do

=DATE(YEAR(A1),1,1)+7-WEEKDAY(DATE(YEAR(A1),1,1),1)+(91)*(ROUNDUP(MONTH( A1)/3,0)-1)

Mike

"Mike H" wrote:

Perhaps,

=DATE(YEAR(A1),1,1)+7-WEEKDAY(DATE(YEAR(A1),1,1),1)+(13*7)*(ROUNDUP(MONT H(A1)/3,0)-1)


Mike

"T. Valko" wrote:

I'm guessing this ought to spark a how short can we get it war

<BG

Let's do it!

--
Biff
Microsoft Excel MVP


"Rick Rothstein" wrote in message
...
I'm guessing this ought to spark a how short can we get it war.... my
formula is two character shorter (with the same number of function
calls).<g

--
Rick (MVP - Excel)


"Ron Rosenfeld" wrote in message
...
On Sun, 8 Mar 2009 15:19:27 -0400, "T. Valko"
wrote:

A few keystrokes shorter:

=DATE(YEAR(A1),INT((MONTH(A1)+2)/3)*3-2,1)+CHOOSE(WEEKDAY(DATE(YEAR(A1),INT((MONTH(A1)+2 )/3)*3-2,1)),6,5,4,3,2,1,0)


And even shorter:

=DATE(YEAR(A1),INT((MONTH(A1)-1)/3)*3+1,0)-WEEKDAY(DATE(YEAR(A1),INT((MONTH(A1)-1)/3)*3+1,0))+7

--ron