• automatically putting in dates like tuesday/thursday

    From rnagy@ualberta.ca@21:1/5 to Myrna Larson on Mon Dec 23 09:37:45 2019
    On Thursday, May 15, 2003 at 1:19:23 PM UTC-6, Myrna Larson wrote:
    What pattern do you want? Just Tues and Thurs every week? Excel can't handle that with automatic
    incrementing since the increment is 2, 5, 2, 5, etc.

    You can do it with a formula:

    Put the first date (a Tue or Thu) in A1. In A2

    =A1+IF(WEEKDAY(A1)=3,2,5)

    and copy down.


    On Thu, 15 May 2003 05:53:39 -0700, "John" <wiljstxs@nospam.com> wrote:

    or Monday Wednesday...

    if i enter a date in one cell and then drag the cell it
    will want to enter dates sequentially...but there must be
    some easy way to enter a different pattern...

    help! thanks in advance!

    :)

    This was very helpful, thank you! :)

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Justin Matthews@21:1/5 to All on Sat Feb 26 21:46:08 2022
    so... these are great but im wanting to have the option after i input the start date for it to auto populate 6 consecutive T/TH, M/W, M/F, W/F, or once a week (every M or every F, etc)...

    so i thought the =E4+if(weekday(E4)=3,2,5) i thought would be great bc then i could enter that sequence into E6 and use the formula =E4+if(weekday(E4)=E6) and using 3,2,5 for T/TH; 2,2,5 for M/W; 2,4,3 for M/F; and 4,2,5 for W/F...

    but... that kicked an error... the formula works perfectly when manually written, but i was trying to make a way to easily choose which cadence all in one cell...

    any solutions?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Justin Matthews@21:1/5 to All on Sat Feb 26 21:33:20 2022
    so... these are great but im wanting to have the option after i input the start date for it to auto populate 6 consecutive m/w or t/th or m/f or w/f...

    the =E4+if(weekday(E4)=3,2,5) i thought would be great bc then i could enter that sequence into E6 and use the formula =E4+if(weekday(E4)=E6)

    but... that kicked an error and i can't figure out the sequence for the other cadences...

    any solutions?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Justin Matthews@21:1/5 to All on Sat Feb 26 21:47:40 2022
    so... these are great but im wanting to have the option after i input the start date for it to auto populate 6 consecutive T/TH, M/W, M/F, W/F, or once a week (every M or every F, etc)...

    so i thought the =E4+if(weekday(E4)=3,2,5) i thought would be great bc then i could enter that sequence into E6 and use the formula =E4+if(weekday(E4)=E6) and using 3,2,5 for T/TH; 2,2,5 for M/W; 2,4,3 for M/F; 4,2,5 for W/F, and 7,7,7 for weekly...

    but... that kicked an error... the formula works perfectly when manually written, but i was trying to make a way to easily choose which cadence all in one cell...

    any solutions?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Katrina Garcia@21:1/5 to Myrna Larson on Sat Apr 29 21:27:05 2023
    Myrna,

    Your formula worked! Thank you!


    On Thursday, May 15, 2003 at 3:19:23 PM UTC-4, Myrna Larson wrote:
    What pattern do you want? Just Tues and Thurs every week? Excel can't handle that with automatic
    incrementing since the increment is 2, 5, 2, 5, etc.
    You can do it with a formula:
    Put the first date (a Tue or Thu) in A1. In A2
    =A1+IF(WEEKDAY(A1)=3,2,5)
    and copy down.
    On Thu, 15 May 2003 05:53:39 -0700, "John" <wilj...@nospam.com> wrote:
    or Monday Wednesday...

    if i enter a date in one cell and then drag the cell it
    will want to enter dates sequentially...but there must be
    some easy way to enter a different pattern...

    help! thanks in advance!

    :)

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Lorenzo Casanova@21:1/5 to Katrina Garcia on Mon Jul 3 17:48:14 2023
    On Saturday, April 29, 2023 at 11:27:06 PM UTC-5, Katrina Garcia wrote:
    Myrna,

    Your formula worked! Thank you!
    On Thursday, May 15, 2003 at 3:19:23 PM UTC-4, Myrna Larson wrote:
    What pattern do you want? Just Tues and Thurs every week? Excel can't handle that with automatic
    incrementing since the increment is 2, 5, 2, 5, etc.
    You can do it with a formula:
    Put the first date (a Tue or Thu) in A1. In A2
    =A1+IF(WEEKDAY(A1)=3,2,5)
    and copy down.
    On Thu, 15 May 2003 05:53:39 -0700, "John" <wilj...@nospam.com> wrote:
    or Monday Wednesday...

    if i enter a date in one cell and then drag the cell it
    will want to enter dates sequentially...but there must be
    some easy way to enter a different pattern...

    help! thanks in advance!

    :)
    Hello, I'm trying to copy the formula for Tuesday and Thursday. I'm not having any luck. I'm looking to start my student roster on cell/D1 on 8/22/2023 and cell/E1 8/24/2023. I need help placing these days into an attendance sheet.

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