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/120754-re-determining-quarter-week-date.html)

Send Object Command - Two attachments

Determining Quarter/Week from Date

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.

All times are GMT +1. The time now is 10:29 PM.