Newbie999
04-07-2020, 01:00 PM
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
04-08-2020, 04:22 AM
1. Sort using dropdown of cell U3, Smallest to Largest
2. Sort using dropdown in cell W3, Newest to Oldest
Newbie999
04-08-2020, 04:33 AM
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
04-08-2020, 04:56 AM
Thanks but I'm not sure what you mean.What?! I can't say it any simpler.
1.
26301
2.
26302
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.