IF Statement with Dates

[JTL9161]

I have a spreadsheet with a list that includes dates going back to 1960.

For this list I am trying to assign a quarter number to each 3 month period based on the date.

1/1/xxxx to 03/31xxxx = Quarter 1
4/1/xxxx to 06/30/xxxx = Qtr. 2
7/1/xxxx to 09/30/xxxx = Qtr. 3
10/1/xxxx to 12/31/xxxx = Qtr. 4

Not sure if formula can ignore year since I am trying to assign quarters all the back to 1960 and am only relying on the month and day to figure each quarter.

Thank you,
James

 

[dreid1011]

Do you even need to look at the day to figure the quarter? For example:

Book1
	A	B	C
1	1/1/2024	1	Qtr. 1
2	1/15/2024	1	Qtr. 1
3	2/1/2024	2	Qtr. 1
4	2/15/2024	2	Qtr. 1
5	5/1/2024	5	Qtr. 2
6	5/15/2024	5	Qtr. 2
7	7/1/2024	7	Qtr. 3
8	7/15/2024	7	Qtr. 3
9	11/1/2024	11	Qtr. 4
10	11/15/2024	11	Qtr. 4
11	6/1/2004	6	Qtr. 2
12	6/15/2004	6	Qtr. 2
13	3/1/1991	3	Qtr. 1
14	3/15/1991	3	Qtr. 1
Sheet1

Cell Formulas
Range	Formula
B1:B14	B1	=MONTH(A1)
C1:C14	C1	="Qtr. "&LOOKUP(MONTH(A1),{1,4,7,10},{1,2,3,4})

What formula are you trying to use?

 

[JTL9161]

DIdn't have one as some Quarter number were already listed. I was just looking for a formula to redo all the dates back to 1960 and make sure they are all correct going forward. True I would only need to look at the month. I think this one will work.

Thanks.

 

[dreid1011]

You're welcome, and happy to help. Let us know if you need something different.