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
 

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

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



"Al" wrote in message
...
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
"Bob Phillips" wrote:

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

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



"Al" wrote in message
...
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.