1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • How to find a date in the future

    From Daddy Sage@21:1/5 to All on Thu Feb 20 22:44:41 2020
    In 2020 February 29 is a Saturday in an uneven week. Next tinme that happens is in 2048, then again in 2076, then in 2116, 2144 and so on. But is there a formula that can calculate this?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claus Busch@21:1/5 to All on Sat Feb 29 16:59:24 2020
    Hi,

    Am Thu, 20 Feb 2020 22:44:41 -0800 (PST) schrieb Daddy Sage:

    In 2020 February 29 is a Saturday in an uneven week. Next tinme that happens is in 2048, then again in 2076, then in 2116, 2144 and so on. But is there a formula that can calculate this?

    try: =SMALL(IF((WEEKDAY(TODAY()+ROW($1:$500000))=7)*(DAY(TODAY()+ROW($1:$500000))=29)*(MONTH(TODAY()+ROW($1:$500000))=2),TODAY()+ROW($1:$500000)),ROW(A1))
    insert the formula with CRTL+Shift+Enter and copy down.


    Regards
    Claus B.
    --
    Windows10
    Office 2016

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