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