Calendar Times Not in Order

[Newbie999]

Hi,

I have array formulas to fill the calendar but the times for the dates aren't in sequential order. Can someone please take a look and possibly come up with a solution? I highlighted P22:P25 yellow to show they are not in order.

Thank you

[p45cal]

1. Sort using dropdown of cell U3, Smallest to Largest
2. Sort using dropdown in cell W3, Newest to Oldest

[Newbie999]

Thanks but I'm not sure what you mean. I did however come up with formula changes on the Calendar. To include the Holidays and Birthdays/Anniversaries I set those times to 12:00 AM and conditionally formatted the text to white on the Calendar range of cells.

In F4:
=IFERROR(SMALL(IF($AB$3:$AB$942=DATE(YEAR(F$3),MONTH(F$3),DAY(F$3)),$Z$3:$Z $942,""),ROW($A1)),"")

In G4:
=IFERROR(INDEX($AA$3:$AA$942,MATCH(SMALL(IF($AB$3:$AB$942=DATE(YEAR(F$3),MO NTH(F$3),DAY(F$3)),$Z$3:$Z$942,""),ROW($A1)),IF($AB$3:$AB$942=DATE(YEAR(F$3),MONTH(F$3),DAY(F$3)),$Z$3:$Z$94 2,""),0)),"")

These are both arrays so they need CTRL+SHIFT+ENTER

Please see the new revision attached.

[p45cal]

Thanks but I'm not sure what you mean.What?! I can't say it any simpler.
1.
26301



2.
26302