View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Send Object Command - Two attachments Send Object Command - Two attachments is offline
external usenet poster
 
Posts: 10
Default Determining Quarter/Week from Date

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.