Help with formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Al - 27 Nov 2007 22:21 GMT

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.

Reply to this Message

Charles Chickering - 27 Nov 2007 22:41 GMT

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

Signature

Charles Chickering

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

> 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.

Reply to this Message

Al - 28 Nov 2007 03:40 GMT

thanks it works

> Al, try this: ="Q" & ROUNDUP(MONTH(D3)/3,0)
>
> > 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.

Reply to this Message