Help with formula
 

I need to write a formula that calculates quarter for dates i.e.

if cell D3 12/31/2006 and <4/1/2007 then "Q1" and so on till Q4.

Help with formula
 

Al, try this: ="Q" & ROUNDUP(MONTH(D3)/3,0)
--
Charles Chickering

"A good example is twice the value of good advice."


"Al" wrote:

I need to write a formula that calculates quarter for dates i.e.

if cell D3 12/31/2006 and <4/1/2007 then "Q1" and so on till Q4.

Help with formula
 

thanks it works

"Charles Chickering" wrote:

Al, try this: ="Q" & ROUNDUP(MONTH(D3)/3,0)
--
Charles Chickering

"A good example is twice the value of good advice."


"Al" wrote:

I need to write a formula that calculates quarter for dates i.e.

if cell D3 12/31/2006 and <4/1/2007 then "Q1" and so on till Q4.