+ Reply to Thread
Results 1 to 4 of 4

repeating a non-sequential pattern

Hybrid View

  1. #1
    Registered User
    Join Date
    07-19-2018
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Smile repeating a non-sequential pattern

    Hi, i'm looking for a way to repeat a set of days (and dates, at the moment the name of the day populates from the date) in the following sequence
    Monday | 1/1/18)
    Tuesday | 2/1/18......
    Wednesday
    Thursday
    Friday
    Saturday | 6/1/18
    Saturday | 6/1/18.....
    Saturday
    Sunday
    Sunday
    Sunday
    Monday
    Tuesday and so on... so normal dates but with 3x saturday and 3x sunday repeating on..

    So that I can just drag this sequence down for the next few years worth of dates... Any ideas appreciated??

    Many thanks. Tom.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: repeating a non-sequential pattern

    A
    B
    2
    Mon 01 Jan 20181/1/2018
    A2: Input
    3
    Tue 02 Jan 20181/2/2018
    A3: =A2+1
    4
    Wed 03 Jan 20181/3/2018
    A4: =A3+1
    5
    Thu 04 Jan 20181/4/2018
    A5: =A4+1
    6
    Fri 05 Jan 20181/5/2018
    A6: =A5+1
    7
    Sat 06 Jan 20181/6/2018
    A7: =A6+1
    8
    Sat 06 Jan 20181/6/2018
    A8: =A7
    9
    Sat 06 Jan 20181/6/2018
    A9: =A8
    10
    Sun 07 Jan 20181/7/2018
    A10: =A9+1
    11
    Sun 07 Jan 20181/7/2018
    A11: =A10
    12
    Sun 07 Jan 20181/7/2018
    A12: =A11
    13
    Mon 08 Jan 20181/8/2018
    A13: =A12+1
    14
    Tue 09 Jan 20181/9/2018
    15
    Wed 10 Jan 20181/10/2018
    16
    Thu 11 Jan 20181/11/2018
    17
    Fri 12 Jan 20181/12/2018
    18
    Sat 13 Jan 20181/13/2018
    19
    Sat 13 Jan 20181/13/2018
    20
    Sat 13 Jan 20181/13/2018
    21
    Sun 14 Jan 20181/14/2018
    22
    Sun 14 Jan 20181/14/2018
    23
    Sun 14 Jan 20181/14/2018
    24
    Mon 15 Jan 20181/15/2018


    Enter A2:A13 as shown, select A3:A13 and drag down.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,494

    Re: repeating a non-sequential pattern

    With the date 1/1/18 in cel B1 the following formula can be put in B2

    =IF(WEEKDAY(B1,2)<6,B1+1,IF(COUNTIF($B$1:B1,B1)<3,B1,B1+1))

    to your liking you can either reformat the column to include the workday (long date formatting) or use a separate cell to show the day name (I put it in A column)
    D column shows the same solution in 1 column.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    07-19-2018
    Location
    London
    MS-Off Ver
    2010
    Posts
    2
    Great, thank you both! I was close to the first one but kept selecting a2 as well which screwed it up...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Repeating a Number pattern by 20's
    By Specialk_102 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-22-2017, 07:36 PM
  2. Identification of a repeating pattern
    By findinganswewrs in forum Excel General
    Replies: 4
    Last Post: 01-27-2017, 03:16 AM
  3. Repeating pattern problem
    By INSIDEOUTE in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-27-2015, 02:36 PM
  4. How to extend sequential id pattern
    By guannarue in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-05-2013, 03:57 PM
  5. Autofill a pattern or repeating sequence
    By awcwa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-03-2013, 12:04 PM
  6. [SOLVED] SOLVED - Need help with a non-sequential number pattern
    By desertdweller in forum Excel - New Users/Basics
    Replies: 17
    Last Post: 10-15-2012, 12:03 PM
  7. Repeating sequential pattern
    By Bdown in forum Excel General
    Replies: 3
    Last Post: 06-07-2012, 05:13 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1