Yo da man!!!
(no offense if you are a woman...)

Thansk!


"bj" wrote:

try
="FY"&YEAR(F2)&"-Q"&(int((Month(F2)-1)/3)+1)

"Send Object Command - Two attachments" wrote:

I am trying to convert a date (01/18/05) to a quarter. I am using this
formula:
="FY"&YEAR(F2)+(MONTH(F2)=4)&"-Q"&INT(1+MOD(MONTH(F2)-4,12)/3)

But my result for this formula is: FY2005-Q4 and it should be FY2005-Q1
(Note, our FY is Jan-Dec)

Can someone help me fix this?

Thanks.