Formula to Calculate Q1, Q2, Q3, or Q4 of the Year?

Topic

New Reply

Hi all,

I need your help again with a formula for a Google Sheet.

Column Q consists of the date I received payment.

I want Column R, which I’m creating, to tell me which quarter — Q1, Q2, Q3, or Q4 — that date falls into. Here’s the key:

Q1 = 01/01 – 03/31
Q2 = 04/01 – 06/30
Q3 = 07/01 – 09/30
Q4 = 10/01 – 12/31

Can you help?

Thanks so much!

Reply | Quote

Replies

Try this slightly long winded version.

=IF(MONTH(Q1)<=3,1,IF(MONTH(Q1)<=6,2,IF(MONTH(Q1)<=9,3,IF(MONTH(Q1)<=12,4))))

Version to return Q1

=IF(MONTH(Q1)<=3,"Q1",IF(MONTH(Q1)<=6,"Q2",IF(MONTH(Q1)<=9,"Q3",IF(MONTH(Q1)<=12,"Q4"))))

cheers, Paul

1 user thanked author for this post.

WSJon5

Reply | Quote

Thanks so much, Paul! That worked!

Reply | Quote