1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • Find 2nd & 4th saturday for every month

    From Girish Mahajan@21:1/5 to All on Thu Apr 8 21:53:43 2021
    This is a very good conversation.
    I do not consider myself as any kind of expert.
    However, I thought that I should share a trick that I discovered.

    If A1 is the cell with the date, then I have used the following formula in the conditional formatting:
    =and(DOW(A1)=7, mod(CEILING(day(A1)/7),2)=1)

    It worked for me. This highlights the second and fourth Saturdays.

    Girish Mahajan

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)