ExcelBanter - Determining Quarter/Week from Date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Determining Quarter/Week from Date (https://www.excelbanter.com/excel-discussion-misc-queries/120834-determining-quarter-week-date.html)

Send Object Command - Two attachments

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.

All times are GMT +1. The time now is 12:13 AM.