Previous Topic Next Topic

Test for quarter of year

Closed
leebittinger Posts 1 Registration date Monday April 4, 2016 Status Member Last seen April 4, 2016 - Apr 4, 2016 at 10:43 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Apr 4, 2016 at 12:06 PM
How do I test for what quarter of the year a date is in?

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
Apr 4, 2016 at 12:06 PM
Hi Leebittinger,

Try this when your date is in A1:
=IF(MONTH(A1)<=3;"1ste quarter";IF(MONTH(A1)<=6;"2nd quarter";IF(MONTH(A1)<=9;"3rd quarter";"4th quarter")))

Best regards,
Trowa

Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.