Consulting

Results 1 to 4 of 4

Thread: Calendar Times Not in Order

  1. #1

    Calendar Times Not in Order

    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
    Attached Files Attached Files

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    1. Sort using dropdown of cell U3, Smallest to Largest
    2. Sort using dropdown in cell W3, Newest to Oldest
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  3. #3
    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$942,""),0)),"")

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

    Please see the new revision attached.
    Attached Files Attached Files

  4. #4
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    Quote Originally Posted by Newbie999 View Post
    Thanks but I'm not sure what you mean.
    What?! I can't say it any simpler.
    1.
    2020-04-08_125238.jpg



    2.
    2020-04-08_125415.jpg
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •