Help with formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Al - 27 Nov 2007 22:18 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

Bob Phillips - 27 Nov 2007 22:41 GMT

="Q"&INT((MONTH(A20)+2)/3)

Signature

---
HTH

Bob

__________________________________________
UK Cambridge XL Users Conference 29-30 Nov
http://www.exceluserconference.com/UKEUC.html

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>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:41 GMT

thanks it works

> ="Q"&INT((MONTH(A20)+2)/3)
>
> >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