Get Quarters (Q1, Q2, Q3 AND Q4) from the given date

Hi Kay,

Thank you for your question

The solution would be to write a nested IF function that applies 3 tests to the month number of each date and returns the appropriate Quarter number with the Q attached. The formula is the following:

="Q"&IF(MONTH(A1)>9,4,IF(MONTH(A1)>6,3,IF(MONTH(A1)>3,2,1)))

So the formula is testing first if any dates that are after September (equivalent to month number 9), then return Quarter number 4. Then the next test is if any dates that are after June (month number 6) return Quarter number 3. The next test is if any dates after March (month number 3),return Quarter number 2. For any other dates that don't meet these tests (eg. January, February and March), then return Quarter number 1

The & is used to 'join' or concatenate the relevant Quarter no. to the letter Q

I hope this makes sense

Kind regards
Martin Sutherland
MOS Applications Trainer