Dropdown List Result in Formula

[MrDB4Excel]

I have searched many sites and cannot seem to get a handle on this, any help will be much appreciated.

How to Get a Formula to Reflect the Year Showing in a Dropdown List
I have this type formula =DATE(YEAR(TODAY()),1,1) showing in multiple cells which then causes conditional formatting to highlight the corresponding cell (in this case New Year’s Day) which contains the following formula:
=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1)=CalendarYear,MONTH(JanSun1)=1),JanSun1,""),IF(AND(YEAR(JanSun1+7)=CalendarYear,MONTH(JanSun1+7)=1),JanSun1+7,""))
The conditional format formula: =VLOOKUP(O7,ImportantDates,1,FALSE)=O7
This formula applies to: =$O$7:$U$12,$X$7:$AD$12,$AG$7:$AM$12,$AP$7:$AV$12,$O$16:$U$21,$X$16:$AD$21,$AG$16:$AM$21,$AP$16:$AV$21,$O$25:$U$30,$X$25:$AD$30,$AG$25:$AM$30,$AP$25:$AV$30
This range encompasses all 12 months of a calendar as seen in the Xl2bb Mini Sheet.
Is it possible for the typical formula =DATE(YEAR(TODAY()),1,1) to get the year from the dropdown list?
In other words when the dropdown is changed to 2023 then the calendars all update with the appropriately highlighted cells per the date indicated by the typical formula =DATE(YEAR(TODAY()),1,1)?
Obviously, by typical formula, I am referring to any of the cells D4 thru D15.

Two Xl2bb Mini Sheets follow because all content of both even though exists all on one sheet will not all come in as one Xl2bb Mini Sheet. The second Xl2bb Mini Sheet only shows January thru April because all 12 months too large for a Mini Sheet.

BogusAnnualCalendar.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1
2				Annual Calendar						2022
3				Important Dates					Notes
4				January 01, 2022		New Year's Day
5				January 04, 2022		John's Birthday
6				January 17, 2022		Patricia's Birthday
7				February 04, 2022		Jennifer's Birthday
8				February 26, 2022		Tom's Birthday
9				February 13, 2022		Elizabeth's Birthday
10				February 24, 2022		Barbara's Birthday
11				March 26, 2022		Nimrod's Birthday
12				April 16, 2022		Jessica's Birthday
13				April 04, 2022		Sarah's Birthday
14				February 20, 2022		Jack's Birthday
15				March 05, 2022		Lisa's Birthday
16
17
Annual Calendar

Cell Formulas
Range	Formula
D4	D4	=DATE(YEAR(TODAY()),1,1)
D5	D5	=DATE(YEAR(TODAY()),1,4)
D6	D6	=DATE(YEAR(TODAY()),1,17)
D7	D7	=DATE(YEAR(TODAY()),2,4)
D8	D8	=DATE(YEAR(TODAY()),2,26)
D9	D9	=DATE(YEAR(TODAY()),2,13)
D10	D10	=DATE(YEAR(TODAY()),2,24)
D11	D11	=DATE(YEAR(TODAY()),3,26)
D12	D12	=DATE(YEAR(TODAY()),4,16)
D13	D13	=DATE(YEAR(TODAY()),4,4)
D14	D14	=DATE(YEAR(TODAY()),2,20)
D15	D15	=DATE(YEAR(TODAY()),3,5)

BogusAnnualCalendar.xlsx
	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV
5	January									February									March									April
6	Su	Mo	Tu	We	Th	Fr	Sa			Su	Mo	Tu	We	Th	Fr	Sa			Su	Mo	Tu	We	Th	Fr	Sa			Su	Mo	Tu	We	Th	Fr	Sa
7							1					1	2	3	4	5					1	2	3	4	5								1	2
8	2	3	4	5	6	7	8			6	7	8	9	10	11	12			6	7	8	9	10	11	12			3	4	5	6	7	8	9
9	9	10	11	12	13	14	15			13	14	15	16	17	18	19			13	14	15	16	17	18	19			10	11	12	13	14	15	16
10	16	17	18	19	20	21	22			20	21	22	23	24	25	26			20	21	22	23	24	25	26			17	18	19	20	21	22	23
11	23	24	25	26	27	28	29			27	28								27	28	29	30	31					24	25	26	27	28	29	30
12	30	31
Annual Calendar

Cell Formulas
Range	Formula
O5	O5	=DATE(CalendarYear,1,1)
X5	X5	=DATE(CalendarYear,2,1)
AG5	AG5	=DATE(CalendarYear,3,1)
AP5	AP5	=DATE(CalendarYear,4,1)
O7	O7	=IF(DAY(JanSun1)=1,"",IF(AND(YEAR(JanSun1+1)=CalendarYear,MONTH(JanSun1+1)=1),JanSun1+1,""))
P7	P7	=IF(DAY(JanSun1)=1,"",IF(AND(YEAR(JanSun1+2)=CalendarYear,MONTH(JanSun1+2)=1),JanSun1+2,""))
Q7	Q7	=IF(DAY(JanSun1)=1,"",IF(AND(YEAR(JanSun1+3)=CalendarYear,MONTH(JanSun1+3)=1),JanSun1+3,""))
R7	R7	=IF(DAY(JanSun1)=1,"",IF(AND(YEAR(JanSun1+4)=CalendarYear,MONTH(JanSun1+4)=1),JanSun1+4,""))
S7	S7	=IF(DAY(JanSun1)=1,"",IF(AND(YEAR(JanSun1+5)=CalendarYear,MONTH(JanSun1+5)=1),JanSun1+5,""))
T7	T7	=IF(DAY(JanSun1)=1,"",IF(AND(YEAR(JanSun1+6)=CalendarYear,MONTH(JanSun1+6)=1),JanSun1+6,""))
U7	U7	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1)=CalendarYear,MONTH(JanSun1)=1),JanSun1,""),IF(AND(YEAR(JanSun1+7)=CalendarYear,MONTH(JanSun1+7)=1),JanSun1+7,""))
O8	O8	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+1)=CalendarYear,MONTH(JanSun1+1)=1),JanSun1+1,""),IF(AND(YEAR(JanSun1+8)=CalendarYear,MONTH(JanSun1+8)=1),JanSun1+8,""))
P8	P8	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+2)=CalendarYear,MONTH(JanSun1+2)=1),JanSun1+2,""),IF(AND(YEAR(JanSun1+9)=CalendarYear,MONTH(JanSun1+9)=1),JanSun1+9,""))
Q8	Q8	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+3)=CalendarYear,MONTH(JanSun1+3)=1),JanSun1+3,""),IF(AND(YEAR(JanSun1+10)=CalendarYear,MONTH(JanSun1+10)=1),JanSun1+10,""))
R8	R8	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+4)=CalendarYear,MONTH(JanSun1+4)=1),JanSun1+4,""),IF(AND(YEAR(JanSun1+11)=CalendarYear,MONTH(JanSun1+11)=1),JanSun1+11,""))
S8	S8	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+5)=CalendarYear,MONTH(JanSun1+5)=1),JanSun1+5,""),IF(AND(YEAR(JanSun1+12)=CalendarYear,MONTH(JanSun1+12)=1),JanSun1+12,""))
T8	T8	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+6)=CalendarYear,MONTH(JanSun1+6)=1),JanSun1+6,""),IF(AND(YEAR(JanSun1+13)=CalendarYear,MONTH(JanSun1+13)=1),JanSun1+13,""))
U8	U8	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+7)=CalendarYear,MONTH(JanSun1+7)=1),JanSun1+7,""),IF(AND(YEAR(JanSun1+14)=CalendarYear,MONTH(JanSun1+14)=1),JanSun1+14,""))
O9	O9	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+8)=CalendarYear,MONTH(JanSun1+8)=1),JanSun1+8,""),IF(AND(YEAR(JanSun1+15)=CalendarYear,MONTH(JanSun1+15)=1),JanSun1+15,""))
P9	P9	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+9)=CalendarYear,MONTH(JanSun1+9)=1),JanSun1+9,""),IF(AND(YEAR(JanSun1+16)=CalendarYear,MONTH(JanSun1+16)=1),JanSun1+16,""))
Q9	Q9	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+10)=CalendarYear,MONTH(JanSun1+10)=1),JanSun1+10,""),IF(AND(YEAR(JanSun1+17)=CalendarYear,MONTH(JanSun1+17)=1),JanSun1+17,""))
R9	R9	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+11)=CalendarYear,MONTH(JanSun1+11)=1),JanSun1+11,""),IF(AND(YEAR(JanSun1+18)=CalendarYear,MONTH(JanSun1+18)=1),JanSun1+18,""))
S9	S9	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+12)=CalendarYear,MONTH(JanSun1+12)=1),JanSun1+12,""),IF(AND(YEAR(JanSun1+19)=CalendarYear,MONTH(JanSun1+19)=1),JanSun1+19,""))
T9	T9	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+13)=CalendarYear,MONTH(JanSun1+13)=1),JanSun1+13,""),IF(AND(YEAR(JanSun1+20)=CalendarYear,MONTH(JanSun1+20)=1),JanSun1+20,""))
U9	U9	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+14)=CalendarYear,MONTH(JanSun1+14)=1),JanSun1+14,""),IF(AND(YEAR(JanSun1+21)=CalendarYear,MONTH(JanSun1+21)=1),JanSun1+21,""))
O10	O10	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+15)=CalendarYear,MONTH(JanSun1+15)=1),JanSun1+15,""),IF(AND(YEAR(JanSun1+22)=CalendarYear,MONTH(JanSun1+22)=1),JanSun1+22,""))
P10	P10	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+16)=CalendarYear,MONTH(JanSun1+16)=1),JanSun1+16,""),IF(AND(YEAR(JanSun1+23)=CalendarYear,MONTH(JanSun1+23)=1),JanSun1+23,""))
Q10	Q10	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+17)=CalendarYear,MONTH(JanSun1+17)=1),JanSun1+17,""),IF(AND(YEAR(JanSun1+24)=CalendarYear,MONTH(JanSun1+24)=1),JanSun1+24,""))
R10	R10	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+18)=CalendarYear,MONTH(JanSun1+18)=1),JanSun1+18,""),IF(AND(YEAR(JanSun1+25)=CalendarYear,MONTH(JanSun1+25)=1),JanSun1+25,""))
S10	S10	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+19)=CalendarYear,MONTH(JanSun1+19)=1),JanSun1+19,""),IF(AND(YEAR(JanSun1+26)=CalendarYear,MONTH(JanSun1+26)=1),JanSun1+26,""))
T10	T10	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+20)=CalendarYear,MONTH(JanSun1+20)=1),JanSun1+20,""),IF(AND(YEAR(JanSun1+27)=CalendarYear,MONTH(JanSun1+27)=1),JanSun1+27,""))
U10	U10	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+21)=CalendarYear,MONTH(JanSun1+21)=1),JanSun1+21,""),IF(AND(YEAR(JanSun1+28)=CalendarYear,MONTH(JanSun1+28)=1),JanSun1+28,""))
O11	O11	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+22)=CalendarYear,MONTH(JanSun1+22)=1),JanSun1+22,""),IF(AND(YEAR(JanSun1+29)=CalendarYear,MONTH(JanSun1+29)=1),JanSun1+29,""))
P11	P11	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+23)=CalendarYear,MONTH(JanSun1+23)=1),JanSun1+23,""),IF(AND(YEAR(JanSun1+30)=CalendarYear,MONTH(JanSun1+30)=1),JanSun1+30,""))
Q11	Q11	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+24)=CalendarYear,MONTH(JanSun1+24)=1),JanSun1+24,""),IF(AND(YEAR(JanSun1+31)=CalendarYear,MONTH(JanSun1+31)=1),JanSun1+31,""))
R11	R11	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+25)=CalendarYear,MONTH(JanSun1+25)=1),JanSun1+25,""),IF(AND(YEAR(JanSun1+32)=CalendarYear,MONTH(JanSun1+32)=1),JanSun1+32,""))
S11	S11	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+26)=CalendarYear,MONTH(JanSun1+26)=1),JanSun1+26,""),IF(AND(YEAR(JanSun1+33)=CalendarYear,MONTH(JanSun1+33)=1),JanSun1+33,""))
T11	T11	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+27)=CalendarYear,MONTH(JanSun1+27)=1),JanSun1+27,""),IF(AND(YEAR(JanSun1+34)=CalendarYear,MONTH(JanSun1+34)=1),JanSun1+34,""))
U11	U11	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+28)=CalendarYear,MONTH(JanSun1+28)=1),JanSun1+28,""),IF(AND(YEAR(JanSun1+35)=CalendarYear,MONTH(JanSun1+35)=1),JanSun1+35,""))
O12	O12	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+29)=CalendarYear,MONTH(JanSun1+29)=1),JanSun1+29,""),IF(AND(YEAR(JanSun1+36)=CalendarYear,MONTH(JanSun1+36)=1),JanSun1+36,""))
P12	P12	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+30)=CalendarYear,MONTH(JanSun1+30)=1),JanSun1+30,""),IF(AND(YEAR(JanSun1+37)=CalendarYear,MONTH(JanSun1+37)=1),JanSun1+37,""))
Q12	Q12	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+31)=CalendarYear,MONTH(JanSun1+31)=1),JanSun1+31,""),IF(AND(YEAR(JanSun1+38)=CalendarYear,MONTH(JanSun1+38)=1),JanSun1+38,""))
R12	R12	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+32)=CalendarYear,MONTH(JanSun1+32)=1),JanSun1+32,""),IF(AND(YEAR(JanSun1+39)=CalendarYear,MONTH(JanSun1+39)=1),JanSun1+39,""))
S12	S12	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+33)=CalendarYear,MONTH(JanSun1+33)=1),JanSun1+33,""),IF(AND(YEAR(JanSun1+40)=CalendarYear,MONTH(JanSun1+40)=1),JanSun1+40,""))
T12	T12	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+34)=CalendarYear,MONTH(JanSun1+34)=1),JanSun1+34,""),IF(AND(YEAR(JanSun1+41)=CalendarYear,MONTH(JanSun1+41)=1),JanSun1+41,""))
U12	U12	=IF(DAY(JanSun1)=1,IF(AND(YEAR(JanSun1+35)=CalendarYear,MONTH(JanSun1+35)=1),JanSun1+35,""),IF(AND(YEAR(JanSun1+42)=CalendarYear,MONTH(JanSun1+42)=1),JanSun1+42,""))
X7	X7	=IF(DAY(FebSun1)=1,"",IF(AND(YEAR(FebSun1+1)=CalendarYear,MONTH(FebSun1+1)=2),FebSun1+1,""))
Y7	Y7	=IF(DAY(FebSun1)=1,"",IF(AND(YEAR(FebSun1+2)=CalendarYear,MONTH(FebSun1+2)=2),FebSun1+2,""))
Z7	Z7	=IF(DAY(FebSun1)=1,"",IF(AND(YEAR(FebSun1+3)=CalendarYear,MONTH(FebSun1+3)=2),FebSun1+3,""))
AA7	AA7	=IF(DAY(FebSun1)=1,"",IF(AND(YEAR(FebSun1+4)=CalendarYear,MONTH(FebSun1+4)=2),FebSun1+4,""))
AB7	AB7	=IF(DAY(FebSun1)=1,"",IF(AND(YEAR(FebSun1+5)=CalendarYear,MONTH(FebSun1+5)=2),FebSun1+5,""))
AC7	AC7	=IF(DAY(FebSun1)=1,"",IF(AND(YEAR(FebSun1+6)=CalendarYear,MONTH(FebSun1+6)=2),FebSun1+6,""))
AD7	AD7	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1)=CalendarYear,MONTH(FebSun1)=2),FebSun1,""),IF(AND(YEAR(FebSun1+7)=CalendarYear,MONTH(FebSun1+7)=2),FebSun1+7,""))
X8	X8	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+1)=CalendarYear,MONTH(FebSun1+1)=2),FebSun1+1,""),IF(AND(YEAR(FebSun1+8)=CalendarYear,MONTH(FebSun1+8)=2),FebSun1+8,""))
Y8	Y8	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+2)=CalendarYear,MONTH(FebSun1+2)=2),FebSun1+2,""),IF(AND(YEAR(FebSun1+9)=CalendarYear,MONTH(FebSun1+9)=2),FebSun1+9,""))
Z8	Z8	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+3)=CalendarYear,MONTH(FebSun1+3)=2),FebSun1+3,""),IF(AND(YEAR(FebSun1+10)=CalendarYear,MONTH(FebSun1+10)=2),FebSun1+10,""))
AA8	AA8	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+4)=CalendarYear,MONTH(FebSun1+4)=2),FebSun1+4,""),IF(AND(YEAR(FebSun1+11)=CalendarYear,MONTH(FebSun1+11)=2),FebSun1+11,""))
AB8	AB8	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+5)=CalendarYear,MONTH(FebSun1+5)=2),FebSun1+5,""),IF(AND(YEAR(FebSun1+12)=CalendarYear,MONTH(FebSun1+12)=2),FebSun1+12,""))
AC8	AC8	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+6)=CalendarYear,MONTH(FebSun1+6)=2),FebSun1+6,""),IF(AND(YEAR(FebSun1+13)=CalendarYear,MONTH(FebSun1+13)=2),FebSun1+13,""))
AD8	AD8	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+7)=CalendarYear,MONTH(FebSun1+7)=2),FebSun1+7,""),IF(AND(YEAR(FebSun1+14)=CalendarYear,MONTH(FebSun1+14)=2),FebSun1+14,""))
X9	X9	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+8)=CalendarYear,MONTH(FebSun1+8)=2),FebSun1+8,""),IF(AND(YEAR(FebSun1+15)=CalendarYear,MONTH(FebSun1+15)=2),FebSun1+15,""))
Y9	Y9	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+9)=CalendarYear,MONTH(FebSun1+9)=2),FebSun1+9,""),IF(AND(YEAR(FebSun1+16)=CalendarYear,MONTH(FebSun1+16)=2),FebSun1+16,""))
Z9	Z9	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+10)=CalendarYear,MONTH(FebSun1+10)=2),FebSun1+10,""),IF(AND(YEAR(FebSun1+17)=CalendarYear,MONTH(FebSun1+17)=2),FebSun1+17,""))
AA9	AA9	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+11)=CalendarYear,MONTH(FebSun1+11)=2),FebSun1+11,""),IF(AND(YEAR(FebSun1+18)=CalendarYear,MONTH(FebSun1+18)=2),FebSun1+18,""))
AB9	AB9	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+12)=CalendarYear,MONTH(FebSun1+12)=2),FebSun1+12,""),IF(AND(YEAR(FebSun1+19)=CalendarYear,MONTH(FebSun1+19)=2),FebSun1+19,""))
AC9	AC9	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+13)=CalendarYear,MONTH(FebSun1+13)=2),FebSun1+13,""),IF(AND(YEAR(FebSun1+20)=CalendarYear,MONTH(FebSun1+20)=2),FebSun1+20,""))
AD9	AD9	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+14)=CalendarYear,MONTH(FebSun1+14)=2),FebSun1+14,""),IF(AND(YEAR(FebSun1+21)=CalendarYear,MONTH(FebSun1+21)=2),FebSun1+21,""))
X10	X10	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+15)=CalendarYear,MONTH(FebSun1+15)=2),FebSun1+15,""),IF(AND(YEAR(FebSun1+22)=CalendarYear,MONTH(FebSun1+22)=2),FebSun1+22,""))
Y10	Y10	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+16)=CalendarYear,MONTH(FebSun1+16)=2),FebSun1+16,""),IF(AND(YEAR(FebSun1+23)=CalendarYear,MONTH(FebSun1+23)=2),FebSun1+23,""))
Z10	Z10	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+17)=CalendarYear,MONTH(FebSun1+17)=2),FebSun1+17,""),IF(AND(YEAR(FebSun1+24)=CalendarYear,MONTH(FebSun1+24)=2),FebSun1+24,""))
AA10	AA10	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+18)=CalendarYear,MONTH(FebSun1+18)=2),FebSun1+18,""),IF(AND(YEAR(FebSun1+25)=CalendarYear,MONTH(FebSun1+25)=2),FebSun1+25,""))
AB10	AB10	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+19)=CalendarYear,MONTH(FebSun1+19)=2),FebSun1+19,""),IF(AND(YEAR(FebSun1+26)=CalendarYear,MONTH(FebSun1+26)=2),FebSun1+26,""))
AC10	AC10	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+20)=CalendarYear,MONTH(FebSun1+20)=2),FebSun1+20,""),IF(AND(YEAR(FebSun1+27)=CalendarYear,MONTH(FebSun1+27)=2),FebSun1+27,""))
AD10	AD10	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+21)=CalendarYear,MONTH(FebSun1+21)=2),FebSun1+21,""),IF(AND(YEAR(FebSun1+28)=CalendarYear,MONTH(FebSun1+28)=2),FebSun1+28,""))
X11	X11	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+22)=CalendarYear,MONTH(FebSun1+22)=2),FebSun1+22,""),IF(AND(YEAR(FebSun1+29)=CalendarYear,MONTH(FebSun1+29)=2),FebSun1+29,""))
Y11	Y11	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+23)=CalendarYear,MONTH(FebSun1+23)=2),FebSun1+23,""),IF(AND(YEAR(FebSun1+30)=CalendarYear,MONTH(FebSun1+30)=2),FebSun1+30,""))
Z11	Z11	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+24)=CalendarYear,MONTH(FebSun1+24)=2),FebSun1+24,""),IF(AND(YEAR(FebSun1+31)=CalendarYear,MONTH(FebSun1+31)=2),FebSun1+31,""))
AA11	AA11	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+25)=CalendarYear,MONTH(FebSun1+25)=2),FebSun1+25,""),IF(AND(YEAR(FebSun1+32)=CalendarYear,MONTH(FebSun1+32)=2),FebSun1+32,""))
AB11	AB11	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+26)=CalendarYear,MONTH(FebSun1+26)=2),FebSun1+26,""),IF(AND(YEAR(FebSun1+33)=CalendarYear,MONTH(FebSun1+33)=2),FebSun1+33,""))
AC11	AC11	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+27)=CalendarYear,MONTH(FebSun1+27)=2),FebSun1+27,""),IF(AND(YEAR(FebSun1+34)=CalendarYear,MONTH(FebSun1+34)=2),FebSun1+34,""))
AD11	AD11	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+28)=CalendarYear,MONTH(FebSun1+28)=2),FebSun1+28,""),IF(AND(YEAR(FebSun1+35)=CalendarYear,MONTH(FebSun1+35)=2),FebSun1+35,""))
X12	X12	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+29)=CalendarYear,MONTH(FebSun1+29)=2),FebSun1+29,""),IF(AND(YEAR(FebSun1+36)=CalendarYear,MONTH(FebSun1+36)=2),FebSun1+36,""))
Y12	Y12	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+30)=CalendarYear,MONTH(FebSun1+30)=2),FebSun1+30,""),IF(AND(YEAR(FebSun1+37)=CalendarYear,MONTH(FebSun1+37)=2),FebSun1+37,""))
Z12	Z12	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+31)=CalendarYear,MONTH(FebSun1+31)=2),FebSun1+31,""),IF(AND(YEAR(FebSun1+38)=CalendarYear,MONTH(FebSun1+38)=2),FebSun1+38,""))
AA12	AA12	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+32)=CalendarYear,MONTH(FebSun1+32)=2),FebSun1+32,""),IF(AND(YEAR(FebSun1+39)=CalendarYear,MONTH(FebSun1+39)=2),FebSun1+39,""))
AB12	AB12	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+33)=CalendarYear,MONTH(FebSun1+33)=2),FebSun1+33,""),IF(AND(YEAR(FebSun1+40)=CalendarYear,MONTH(FebSun1+40)=2),FebSun1+40,""))
AC12	AC12	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+34)=CalendarYear,MONTH(FebSun1+34)=2),FebSun1+34,""),IF(AND(YEAR(FebSun1+41)=CalendarYear,MONTH(FebSun1+41)=2),FebSun1+41,""))
AD12	AD12	=IF(DAY(FebSun1)=1,IF(AND(YEAR(FebSun1+35)=CalendarYear,MONTH(FebSun1+35)=2),FebSun1+35,""),IF(AND(YEAR(FebSun1+42)=CalendarYear,MONTH(FebSun1+42)=2),FebSun1+42,""))
AG7	AG7	=IF(DAY(MarSun1)=1,"",IF(AND(YEAR(MarSun1+1)=CalendarYear,MONTH(MarSun1+1)=3),MarSun1+1,""))
AH7	AH7	=IF(DAY(MarSun1)=1,"",IF(AND(YEAR(MarSun1+2)=CalendarYear,MONTH(MarSun1+2)=3),MarSun1+2,""))
AI7	AI7	=IF(DAY(MarSun1)=1,"",IF(AND(YEAR(MarSun1+3)=CalendarYear,MONTH(MarSun1+3)=3),MarSun1+3,""))
AJ7	AJ7	=IF(DAY(MarSun1)=1,"",IF(AND(YEAR(MarSun1+4)=CalendarYear,MONTH(MarSun1+4)=3),MarSun1+4,""))
AK7	AK7	=IF(DAY(MarSun1)=1,"",IF(AND(YEAR(MarSun1+5)=CalendarYear,MONTH(MarSun1+5)=3),MarSun1+5,""))
AL7	AL7	=IF(DAY(MarSun1)=1,"",IF(AND(YEAR(MarSun1+6)=CalendarYear,MONTH(MarSun1+6)=3),MarSun1+6,""))
AM7	AM7	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1)=CalendarYear,MONTH(MarSun1)=3),MarSun1,""),IF(AND(YEAR(MarSun1+7)=CalendarYear,MONTH(MarSun1+7)=3),MarSun1+7,""))
AG8	AG8	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+1)=CalendarYear,MONTH(MarSun1+1)=3),MarSun1+1,""),IF(AND(YEAR(MarSun1+8)=CalendarYear,MONTH(MarSun1+8)=3),MarSun1+8,""))
AH8	AH8	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+2)=CalendarYear,MONTH(MarSun1+2)=3),MarSun1+2,""),IF(AND(YEAR(MarSun1+9)=CalendarYear,MONTH(MarSun1+9)=3),MarSun1+9,""))
AI8	AI8	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+3)=CalendarYear,MONTH(MarSun1+3)=3),MarSun1+3,""),IF(AND(YEAR(MarSun1+10)=CalendarYear,MONTH(MarSun1+10)=3),MarSun1+10,""))
AJ8	AJ8	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+4)=CalendarYear,MONTH(MarSun1+4)=3),MarSun1+4,""),IF(AND(YEAR(MarSun1+11)=CalendarYear,MONTH(MarSun1+11)=3),MarSun1+11,""))
AK8	AK8	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+5)=CalendarYear,MONTH(MarSun1+5)=3),MarSun1+5,""),IF(AND(YEAR(MarSun1+12)=CalendarYear,MONTH(MarSun1+12)=3),MarSun1+12,""))
AL8	AL8	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+6)=CalendarYear,MONTH(MarSun1+6)=3),MarSun1+6,""),IF(AND(YEAR(MarSun1+13)=CalendarYear,MONTH(MarSun1+13)=3),MarSun1+13,""))
AM8	AM8	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+7)=CalendarYear,MONTH(MarSun1+7)=3),MarSun1+7,""),IF(AND(YEAR(MarSun1+14)=CalendarYear,MONTH(MarSun1+14)=3),MarSun1+14,""))
AG9	AG9	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+8)=CalendarYear,MONTH(MarSun1+8)=3),MarSun1+8,""),IF(AND(YEAR(MarSun1+15)=CalendarYear,MONTH(MarSun1+15)=3),MarSun1+15,""))
AH9	AH9	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+9)=CalendarYear,MONTH(MarSun1+9)=3),MarSun1+9,""),IF(AND(YEAR(MarSun1+16)=CalendarYear,MONTH(MarSun1+16)=3),MarSun1+16,""))
AI9	AI9	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+10)=CalendarYear,MONTH(MarSun1+10)=3),MarSun1+10,""),IF(AND(YEAR(MarSun1+17)=CalendarYear,MONTH(MarSun1+17)=3),MarSun1+17,""))
AJ9	AJ9	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+11)=CalendarYear,MONTH(MarSun1+11)=3),MarSun1+11,""),IF(AND(YEAR(MarSun1+18)=CalendarYear,MONTH(MarSun1+18)=3),MarSun1+18,""))
AK9	AK9	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+12)=CalendarYear,MONTH(MarSun1+12)=3),MarSun1+12,""),IF(AND(YEAR(MarSun1+19)=CalendarYear,MONTH(MarSun1+19)=3),MarSun1+19,""))
AL9	AL9	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+13)=CalendarYear,MONTH(MarSun1+13)=3),MarSun1+13,""),IF(AND(YEAR(MarSun1+20)=CalendarYear,MONTH(MarSun1+20)=3),MarSun1+20,""))
AM9	AM9	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+14)=CalendarYear,MONTH(MarSun1+14)=3),MarSun1+14,""),IF(AND(YEAR(MarSun1+21)=CalendarYear,MONTH(MarSun1+21)=3),MarSun1+21,""))
AG10	AG10	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+15)=CalendarYear,MONTH(MarSun1+15)=3),MarSun1+15,""),IF(AND(YEAR(MarSun1+22)=CalendarYear,MONTH(MarSun1+22)=3),MarSun1+22,""))
AH10	AH10	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+16)=CalendarYear,MONTH(MarSun1+16)=3),MarSun1+16,""),IF(AND(YEAR(MarSun1+23)=CalendarYear,MONTH(MarSun1+23)=3),MarSun1+23,""))
AI10	AI10	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+17)=CalendarYear,MONTH(MarSun1+17)=3),MarSun1+17,""),IF(AND(YEAR(MarSun1+24)=CalendarYear,MONTH(MarSun1+24)=3),MarSun1+24,""))
AJ10	AJ10	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+18)=CalendarYear,MONTH(MarSun1+18)=3),MarSun1+18,""),IF(AND(YEAR(MarSun1+25)=CalendarYear,MONTH(MarSun1+25)=3),MarSun1+25,""))
AK10	AK10	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+19)=CalendarYear,MONTH(MarSun1+19)=3),MarSun1+19,""),IF(AND(YEAR(MarSun1+26)=CalendarYear,MONTH(MarSun1+26)=3),MarSun1+26,""))
AL10	AL10	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+20)=CalendarYear,MONTH(MarSun1+20)=3),MarSun1+20,""),IF(AND(YEAR(MarSun1+27)=CalendarYear,MONTH(MarSun1+27)=3),MarSun1+27,""))
AM10	AM10	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+21)=CalendarYear,MONTH(MarSun1+21)=3),MarSun1+21,""),IF(AND(YEAR(MarSun1+28)=CalendarYear,MONTH(MarSun1+28)=3),MarSun1+28,""))
AG11	AG11	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+22)=CalendarYear,MONTH(MarSun1+22)=3),MarSun1+22,""),IF(AND(YEAR(MarSun1+29)=CalendarYear,MONTH(MarSun1+29)=3),MarSun1+29,""))
AH11	AH11	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+23)=CalendarYear,MONTH(MarSun1+23)=3),MarSun1+23,""),IF(AND(YEAR(MarSun1+30)=CalendarYear,MONTH(MarSun1+30)=3),MarSun1+30,""))
AI11	AI11	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+24)=CalendarYear,MONTH(MarSun1+24)=3),MarSun1+24,""),IF(AND(YEAR(MarSun1+31)=CalendarYear,MONTH(MarSun1+31)=3),MarSun1+31,""))
AJ11	AJ11	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+25)=CalendarYear,MONTH(MarSun1+25)=3),MarSun1+25,""),IF(AND(YEAR(MarSun1+32)=CalendarYear,MONTH(MarSun1+32)=3),MarSun1+32,""))
AK11	AK11	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+26)=CalendarYear,MONTH(MarSun1+26)=3),MarSun1+26,""),IF(AND(YEAR(MarSun1+33)=CalendarYear,MONTH(MarSun1+33)=3),MarSun1+33,""))
AL11	AL11	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+27)=CalendarYear,MONTH(MarSun1+27)=3),MarSun1+27,""),IF(AND(YEAR(MarSun1+34)=CalendarYear,MONTH(MarSun1+34)=3),MarSun1+34,""))
AM11	AM11	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+28)=CalendarYear,MONTH(MarSun1+28)=3),MarSun1+28,""),IF(AND(YEAR(MarSun1+35)=CalendarYear,MONTH(MarSun1+35)=3),MarSun1+35,""))
AG12	AG12	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+29)=CalendarYear,MONTH(MarSun1+29)=3),MarSun1+29,""),IF(AND(YEAR(MarSun1+36)=CalendarYear,MONTH(MarSun1+36)=3),MarSun1+36,""))
AH12	AH12	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+30)=CalendarYear,MONTH(MarSun1+30)=3),MarSun1+30,""),IF(AND(YEAR(MarSun1+37)=CalendarYear,MONTH(MarSun1+37)=3),MarSun1+37,""))
AI12	AI12	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+31)=CalendarYear,MONTH(MarSun1+31)=3),MarSun1+31,""),IF(AND(YEAR(MarSun1+38)=CalendarYear,MONTH(MarSun1+38)=3),MarSun1+38,""))
AJ12	AJ12	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+32)=CalendarYear,MONTH(MarSun1+32)=3),MarSun1+32,""),IF(AND(YEAR(MarSun1+39)=CalendarYear,MONTH(MarSun1+39)=3),MarSun1+39,""))
AK12	AK12	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+33)=CalendarYear,MONTH(MarSun1+33)=3),MarSun1+33,""),IF(AND(YEAR(MarSun1+40)=CalendarYear,MONTH(MarSun1+40)=3),MarSun1+40,""))
AL12	AL12	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+34)=CalendarYear,MONTH(MarSun1+34)=3),MarSun1+34,""),IF(AND(YEAR(MarSun1+41)=CalendarYear,MONTH(MarSun1+41)=3),MarSun1+41,""))
AM12	AM12	=IF(DAY(MarSun1)=1,IF(AND(YEAR(MarSun1+35)=CalendarYear,MONTH(MarSun1+35)=3),MarSun1+35,""),IF(AND(YEAR(MarSun1+42)=CalendarYear,MONTH(MarSun1+42)=3),MarSun1+42,""))
AP7	AP7	=IF(DAY(AprSun1)=1,"",IF(AND(YEAR(AprSun1+1)=CalendarYear,MONTH(AprSun1+1)=4),AprSun1+1,""))
AQ7	AQ7	=IF(DAY(AprSun1)=1,"",IF(AND(YEAR(AprSun1+2)=CalendarYear,MONTH(AprSun1+2)=4),AprSun1+2,""))
AR7	AR7	=IF(DAY(AprSun1)=1,"",IF(AND(YEAR(AprSun1+3)=CalendarYear,MONTH(AprSun1+3)=4),AprSun1+3,""))
AS7	AS7	=IF(DAY(AprSun1)=1,"",IF(AND(YEAR(AprSun1+4)=CalendarYear,MONTH(AprSun1+4)=4),AprSun1+4,""))
AT7	AT7	=IF(DAY(AprSun1)=1,"",IF(AND(YEAR(AprSun1+5)=CalendarYear,MONTH(AprSun1+5)=4),AprSun1+5,""))
AU7	AU7	=IF(DAY(AprSun1)=1,"",IF(AND(YEAR(AprSun1+6)=CalendarYear,MONTH(AprSun1+6)=4),AprSun1+6,""))
AV7	AV7	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1)=CalendarYear,MONTH(AprSun1)=4),AprSun1,""),IF(AND(YEAR(AprSun1+7)=CalendarYear,MONTH(AprSun1+7)=4),AprSun1+7,""))
AP8	AP8	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+1)=CalendarYear,MONTH(AprSun1+1)=4),AprSun1+1,""),IF(AND(YEAR(AprSun1+8)=CalendarYear,MONTH(AprSun1+8)=4),AprSun1+8,""))
AQ8	AQ8	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+2)=CalendarYear,MONTH(AprSun1+2)=4),AprSun1+2,""),IF(AND(YEAR(AprSun1+9)=CalendarYear,MONTH(AprSun1+9)=4),AprSun1+9,""))
AR8	AR8	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+3)=CalendarYear,MONTH(AprSun1+3)=4),AprSun1+3,""),IF(AND(YEAR(AprSun1+10)=CalendarYear,MONTH(AprSun1+10)=4),AprSun1+10,""))
AS8	AS8	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+4)=CalendarYear,MONTH(AprSun1+4)=4),AprSun1+4,""),IF(AND(YEAR(AprSun1+11)=CalendarYear,MONTH(AprSun1+11)=4),AprSun1+11,""))
AT8	AT8	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+5)=CalendarYear,MONTH(AprSun1+5)=4),AprSun1+5,""),IF(AND(YEAR(AprSun1+12)=CalendarYear,MONTH(AprSun1+12)=4),AprSun1+12,""))
AU8	AU8	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+6)=CalendarYear,MONTH(AprSun1+6)=4),AprSun1+6,""),IF(AND(YEAR(AprSun1+13)=CalendarYear,MONTH(AprSun1+13)=4),AprSun1+13,""))
AV8	AV8	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+7)=CalendarYear,MONTH(AprSun1+7)=4),AprSun1+7,""),IF(AND(YEAR(AprSun1+14)=CalendarYear,MONTH(AprSun1+14)=4),AprSun1+14,""))
AP9	AP9	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+8)=CalendarYear,MONTH(AprSun1+8)=4),AprSun1+8,""),IF(AND(YEAR(AprSun1+15)=CalendarYear,MONTH(AprSun1+15)=4),AprSun1+15,""))
AQ9	AQ9	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+9)=CalendarYear,MONTH(AprSun1+9)=4),AprSun1+9,""),IF(AND(YEAR(AprSun1+16)=CalendarYear,MONTH(AprSun1+16)=4),AprSun1+16,""))
AR9	AR9	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+10)=CalendarYear,MONTH(AprSun1+10)=4),AprSun1+10,""),IF(AND(YEAR(AprSun1+17)=CalendarYear,MONTH(AprSun1+17)=4),AprSun1+17,""))
AS9	AS9	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+11)=CalendarYear,MONTH(AprSun1+11)=4),AprSun1+11,""),IF(AND(YEAR(AprSun1+18)=CalendarYear,MONTH(AprSun1+18)=4),AprSun1+18,""))
AT9	AT9	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+12)=CalendarYear,MONTH(AprSun1+12)=4),AprSun1+12,""),IF(AND(YEAR(AprSun1+19)=CalendarYear,MONTH(AprSun1+19)=4),AprSun1+19,""))
AU9	AU9	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+13)=CalendarYear,MONTH(AprSun1+13)=4),AprSun1+13,""),IF(AND(YEAR(AprSun1+20)=CalendarYear,MONTH(AprSun1+20)=4),AprSun1+20,""))
AV9	AV9	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+14)=CalendarYear,MONTH(AprSun1+14)=4),AprSun1+14,""),IF(AND(YEAR(AprSun1+21)=CalendarYear,MONTH(AprSun1+21)=4),AprSun1+21,""))
AP10	AP10	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+15)=CalendarYear,MONTH(AprSun1+15)=4),AprSun1+15,""),IF(AND(YEAR(AprSun1+22)=CalendarYear,MONTH(AprSun1+22)=4),AprSun1+22,""))
AQ10	AQ10	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+16)=CalendarYear,MONTH(AprSun1+16)=4),AprSun1+16,""),IF(AND(YEAR(AprSun1+23)=CalendarYear,MONTH(AprSun1+23)=4),AprSun1+23,""))
AR10	AR10	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+17)=CalendarYear,MONTH(AprSun1+17)=4),AprSun1+17,""),IF(AND(YEAR(AprSun1+24)=CalendarYear,MONTH(AprSun1+24)=4),AprSun1+24,""))
AS10	AS10	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+18)=CalendarYear,MONTH(AprSun1+18)=4),AprSun1+18,""),IF(AND(YEAR(AprSun1+25)=CalendarYear,MONTH(AprSun1+25)=4),AprSun1+25,""))
AT10	AT10	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+19)=CalendarYear,MONTH(AprSun1+19)=4),AprSun1+19,""),IF(AND(YEAR(AprSun1+26)=CalendarYear,MONTH(AprSun1+26)=4),AprSun1+26,""))
AU10	AU10	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+20)=CalendarYear,MONTH(AprSun1+20)=4),AprSun1+20,""),IF(AND(YEAR(AprSun1+27)=CalendarYear,MONTH(AprSun1+27)=4),AprSun1+27,""))
AV10	AV10	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+21)=CalendarYear,MONTH(AprSun1+21)=4),AprSun1+21,""),IF(AND(YEAR(AprSun1+28)=CalendarYear,MONTH(AprSun1+28)=4),AprSun1+28,""))
AP11	AP11	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+22)=CalendarYear,MONTH(AprSun1+22)=4),AprSun1+22,""),IF(AND(YEAR(AprSun1+29)=CalendarYear,MONTH(AprSun1+29)=4),AprSun1+29,""))
AQ11	AQ11	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+23)=CalendarYear,MONTH(AprSun1+23)=4),AprSun1+23,""),IF(AND(YEAR(AprSun1+30)=CalendarYear,MONTH(AprSun1+30)=4),AprSun1+30,""))
AR11	AR11	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+24)=CalendarYear,MONTH(AprSun1+24)=4),AprSun1+24,""),IF(AND(YEAR(AprSun1+31)=CalendarYear,MONTH(AprSun1+31)=4),AprSun1+31,""))
AS11	AS11	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+25)=CalendarYear,MONTH(AprSun1+25)=4),AprSun1+25,""),IF(AND(YEAR(AprSun1+32)=CalendarYear,MONTH(AprSun1+32)=4),AprSun1+32,""))
AT11	AT11	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+26)=CalendarYear,MONTH(AprSun1+26)=4),AprSun1+26,""),IF(AND(YEAR(AprSun1+33)=CalendarYear,MONTH(AprSun1+33)=4),AprSun1+33,""))
AU11	AU11	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+27)=CalendarYear,MONTH(AprSun1+27)=4),AprSun1+27,""),IF(AND(YEAR(AprSun1+34)=CalendarYear,MONTH(AprSun1+34)=4),AprSun1+34,""))
AV11	AV11	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+28)=CalendarYear,MONTH(AprSun1+28)=4),AprSun1+28,""),IF(AND(YEAR(AprSun1+35)=CalendarYear,MONTH(AprSun1+35)=4),AprSun1+35,""))
AP12	AP12	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+29)=CalendarYear,MONTH(AprSun1+29)=4),AprSun1+29,""),IF(AND(YEAR(AprSun1+36)=CalendarYear,MONTH(AprSun1+36)=4),AprSun1+36,""))
AQ12	AQ12	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+30)=CalendarYear,MONTH(AprSun1+30)=4),AprSun1+30,""),IF(AND(YEAR(AprSun1+37)=CalendarYear,MONTH(AprSun1+37)=4),AprSun1+37,""))
AR12	AR12	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+31)=CalendarYear,MONTH(AprSun1+31)=4),AprSun1+31,""),IF(AND(YEAR(AprSun1+38)=CalendarYear,MONTH(AprSun1+38)=4),AprSun1+38,""))
AS12	AS12	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+32)=CalendarYear,MONTH(AprSun1+32)=4),AprSun1+32,""),IF(AND(YEAR(AprSun1+39)=CalendarYear,MONTH(AprSun1+39)=4),AprSun1+39,""))
AT12	AT12	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+33)=CalendarYear,MONTH(AprSun1+33)=4),AprSun1+33,""),IF(AND(YEAR(AprSun1+40)=CalendarYear,MONTH(AprSun1+40)=4),AprSun1+40,""))
AU12	AU12	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+34)=CalendarYear,MONTH(AprSun1+34)=4),AprSun1+34,""),IF(AND(YEAR(AprSun1+41)=CalendarYear,MONTH(AprSun1+41)=4),AprSun1+41,""))
AV12	AV12	=IF(DAY(AprSun1)=1,IF(AND(YEAR(AprSun1+35)=CalendarYear,MONTH(AprSun1+35)=4),AprSun1+35,""),IF(AND(YEAR(AprSun1+42)=CalendarYear,MONTH(AprSun1+42)=4),AprSun1+42,""))

Named Ranges
Name	Refers To	Cells
CalendarYear	='Annual Calendar'!$J$2	AP5:AV5, AG5:AM5, X5:AD5, O5:U5, O7:U12, X7:AD12, AG7:AM12, AP7:AV12

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O7:U12,X7:AD12,AG7:AM12,AP7:AV12,O16:U21,X16:AD21,AG16:AM21,AP16:AV21,O25:U30,X25:AD30,AG25:AM30,AP25:AV30	Expression	=VLOOKUP(O7,ImportantDates,1,FALSE)=O7	text	NO

 

[Fluff]

How about

=DATE(J$2,1,1)

 

[MrDB4Excel]

Perfect, and so easy. I am duly impressed. Many thanks Fluff

 

[Fluff]

You're welcome & thanks for the feedback.