Comments on: How to create a sequence of dates in Excel and auto fill date series

Until recently, there has been just one easy way to generate dates in Excel - the AutoFill feature. The introduction of the new dynamic array SEQUENCE function has made it possible to make a series of dates with a formula too. This tutorial takes an in-depth look at both methods so that you can choose the one that works best for you. Continue reading →

Comments page 2. Total comments: 203

  1. Hi,

    I need make a list of days and every hour of every day.

    ie.

    1/1/2023 00:00
    1/1/2023 01:00
    1/1/2023 02:00

    for all 365 days

  2. Hi! Can someone help me?

    I have a start date and finish date.
    I want to count the number of days from start to finish date that is within another set of start date to today date.

    Thank you so much!

    Example:
    Days to count >>>
    Start Date: August 1
    Finish Date: August 5

    Within thus Date range
    Start Date: July 31
    Today Date: August 4

    Thank you so much!

    1. Hi! If I understand correctly, you want to count the number of dates that are included in both of these time intervals. Use SUMPRODUCT function:

      =SUMPRODUCT(--(A1:A10>=MAX(B1:C1)),--(A1:A10<=MIN(B2:C2)))

      B1,B2 - first date range, C1,C2 - second date range.

  3. Hi, may I know which formula could I use to calculate total hours for overtime done by employee. I also have a problem of fixing the time in and time out format to generate the total hours automatically.
    Thank you in advance

  4. Hello, I need generate a secuence of duplicate dates using vba such as:

    15/09/2023 9:13 p. m. 20/09/2023
    16/09/2023 9:13 a. m. $15.000
    16/09/2023 9:13 p. m. $15.000
    17/09/2023 9:13 a. m. $15.000
    17/09/2023 9:13 p. m. $15.000
    18/09/2023 9:13 a. m. $15.000
    18/09/2023 9:13 p. m. $15.000
    19/09/2023 9:13 a. m. $15.000
    19/09/2023 9:13 p. m. $15.000
    20/09/2023 9:13 a. m. $15.000
    20/09/2023 9:13 p. m. $15.000

    Thanks a lot

  5. Hi there,

    Do you know how I would go about creating dates for a 4 on and 4 off shift pattern?

    For example:
    Start Date 28/07/2023

    28/07/2023
    29/07/2023
    30/07/2023
    31/07/2023
    05/08/2023
    06/08/2023
    07/08/2023
    08/08/2023
    13/08/2023
    14/08/2023
    15/08/2023
    16/08/2023

    Hope this makes sense!

    Any help would be much appreciated :)

  6. Hi

    I'm trying to create a registers using excel where the class is only seen 2 days a week
    For example I would like it to read

    Monday 04/09/2023
    Wednesday 06/09/2023
    Monday 11/09/2023
    Wednesday 13/09/2023

    etc
    Is this possible?

  7. I am trying to create a series of dates which I want to sort into a larger collection of dates.
    Surely there is a simple way to do this!

    It appears if I use the SEQUENCE formula to create the list that I am not able to sort this list.
    When I do a right click on the Fill handle of a cell that has a date from which I wish to create a date list, I am not able to select any options - they are all greyed out.
    It used to be that you could start a date list with a minimum of three dates and then use the Fill handle to extend the list into the future but now all that seems to happen when I do this is a replication of the dates in the list, not a continuation of the list.

    Any other suggestions?

  8. I'm trying to fill a sequence for the end of every quarter starting on 9-23:
    09-23
    12-23
    03-24
    06-24
    09-24
    12-24
    03-25...

    1. Hi! Use the EOMONTH function to create a sequence of dates with an interval of 3 months. Use the TEXT function to get these dates in the format "mm-yyy".
      Check the formula below, it should work for you:

      =TEXT(EOMONTH(DATE(2023,9,1),SEQUENCE(20,,3,3)-3),"mm-yy")

  9. Hi. How can I create a sequence of dates of workdays like Monday, Wednesday, Friday or Monday to Friday. I want the formula to give me the dates of a month for Monday Wednesday Friday each week. For example for August 2023, I want the formula to give me the below dates; 2nd, 4th,7th,9th,11th,14th,16th,18th,21th,23th,25th,28th,30th.
    Is it poosibe to get that data with excel?

    1. Hi! To create a sequence of working days, try using the WORKDAY.INTL function.
      Use argument "Weekend string", as described in this article.

      =WORKDAY.INTL(A1,1,"0101011")
      A1 - start date (1 Aug 2023)
      Try to enter the following formula in cell A2 and then copy it down along the column.

  10. Two dates in excel cell like 12-01-2005 & 15-02-2008
    we want in another cells as result 31-03-2005,30-06-2005,30-09-2005,31-12-2005,31-03-2006,30-06-2006,30-09-2006,31-12-2006,31-03-2007,30-06-2007,30-09-2007,31-12-2007,29-02-2008,
    How we can do with macro.

  11. I have a table with a calendar that I want to populate with a 'check mark' on specific days in a sequence. Essentially I want to take a start date for a task and a frequency for said task, and have it put a check mark on the dates at regular intervals. Is there a simple formula that would generate a sequence for me?

    1. As we have written many times on this blog, a formula cannot change the value in another cell. Use VBA.

  12. I'm trying to repeat a sequence after every 21 rows, like first 21 rows have "7" then next 21 rows will have "8" again next 21 rows will have "9" and this will continue. how this can be achieved.

  13. I'm trying to repeat a date sequence after every 7 rows, like first 7 rows have date 6-8-23 then next 7 rows will have 7-8-23 and this will continue. how this can be achieved.

    1. Hi! To create a sequence with repeating values, use the CEILING function together with SEQUENCE. Add these values to the start date. Try this formula:

      =CEILING(SEQUENCE(49,1,1,1)/7,1)+DATE(2023,8,5)

  14. I need to make sequence like this as given below, Please help me on this

    01 - 01/07/2023 00:00
    01 - 01/07/2023 00:10
    .
    .
    .
    01 - 01/07/2023 23:50
    01 - 02/07/2023 00:00
    02 - 01/07/2023 00:00
    02 - 01/07/2023 00:10
    .
    .
    .
    112 - 02/07/2023 00:00

  15. Hi,
    I have data which has been recorded every 15 minutes from between 4/1/2020-27/4/2020.
    I need to code it using R so require the layout of this spreadsheet to require 2 separate columns of date and time.
    I have added the time column but I need the date to essentially remain the same for each 24 hour period and increase by 1.
    e.g.
    4/1/2020 | 00:00:00
    4/1/2020 | 00:15:00
    4/1/2020 | 00:30:00
    ...
    ...
    ...
    4/1/2020 | 23:45:00
    5/1/2020 | 00:00:00
    5/1/2020 | 00:15:00

    and so on

    Could you help with this?
    Thanks

      1. That works perfectly - thank you!

  16. I am hoping to create a excel spreadsheet that has the days of the month populate across column 5 and change monthly based on the number of days in that month I also would like to highlight every row that is a sunday hoping I can get assistance with this

    1. Hi! If I got you right, the formula below will help you with your task:

      =EOMONTH(TODAY(),-1) + SEQUENCE(DAY(EOMONTH(TODAY(),0)),1,1,1)

      You can learn more about EOMONTH function in Excel in this article on our blog

  17. Hello, I am currently working on my study plan, and willing to share it to my friends. I would like to be able to auto change the date of each topic based on the individual's chosen number of study sessions per day.

    For example:

    In cell A1, there is an option to choose the numbers: 1 or 2 or 3 - study sessions per day.

    If I choose 1 session per day this is what the column looks like:

    column B
    July 5, 2023
    July 6, 2023
    July 7, 2023
    and so on

    For 2 sessions per day

    same column B
    July 5, 2023
    July 5, 2023
    July 6, 2023
    July 6, 2023

    Again, I would like to be able to auto sequence change the whole column based on the chosen session in cell A1.

    Thank you, I really appreciate your help! Good day!

    1. Hi! If I understand your task correctly, the following formula should work for you:

      =B1+CEILING(SEQUENCE(30,1,1,1)/A1,1)

      B1 - start date

  18. I'm looking for a way, starting from 1/1/23, to have excel pull dates through the rest of the year in the following pattern: 2,3,6,7,8,11,12 (these numbers come from a 1-14 or two week interval). So for example it would return:
    2- 1/2/23
    3- 1/3/23
    6- 1/6/23
    7- 1/7/23
    8- 1/8/23
    11- 1/11/23
    12- 1/12/23
    2- 1/16/23
    3- 1/17/23
    6- 1/20/23
    7- 1/21/23
    8- 1/22/23
    11- 1/25/23
    12- 1/26/23
    2- 1/30/23
    3- 1/31/23

    1. Hi! Unfortunately, I don't see any logical sequence in your numbers that can be written as a formula. If you see logic in these numbers, tell me.

  19. I've tryed to use the sequence creatio formula =WORKDAY(B2-1, SEQUENCE(B1)) and it works fine but I can't the column generenated within a vlookup array it simple doesn't read it as dates

    1. Hi! If cell B2 contains the date, check what value you are searching for with VLOOKUP. It may be a text.

  20. Hi. I am scouring the internet trying to find a way to store ranges of dates in excel, that automatically adjust based on the current month. So I have a list of events, and each event runs from X day to Y day. Some go into the following month. For example, Event A runs from the 12th of the month to the 08th of the following month. Is there a formula that will automatically update this for me based on today's date, in excel?

  21. if i put a date in a cell, and if the date a sunday i have to display and "S" with the date in same cell

    1. Hi! You can only add a character to a cell with a date by using a VBA macro. And then you will get text in the cell, not the date. To show the day of the week, use a custom date format. For example: ddd, mmmm dd, yyyy

  22. I am wanting to have the next date at the top and the last date at the bottom. Can anyone help please

    1. Hi! If you want to get a descending sequence of dates from a future date to a past date, use a negative number in the [step] argument of the SEQUENCE function. For example,
      =SEQUENCE(10, 1, "8/1/2020", -1)
      Hope this is what you need.

  23. Greetings,
    My issue is probably going to be easy and I just am over looking how. I am trying to create a month long series of
    workbook pages with page 1 being the "1st" next "2nd" etc.
    Id like the entire date (mm/dd/yy) for each page to be in C1 of every page auto advancing. What am I missing to do so?
    Thank you in advance.

  24. Hi there,
    I would like to create a series of dates on columns across the top of a spreadsheet as they are reading infro from different tabs.

    e.g,
    3 Apr 23 3 Apr 23 3 Apr 23 10 Apr 23 10 Apr 23 10 Apr 23 17 Apr 23 17 Apr 23 17 Apr 23 and so on

    Therefore repeating the date 3 times across the top then going up by one week and repeating the same pattern I hop that makes sense

    Thanks in advance for your help.

  25. I am needing help with a formula that would allow me to have the same date in 'x' amount of rows (for this example lets say 5 rows) and then it changes to the next day for the next 5 rows and so on and so forth. With that being said, I want to only include weekdays (Monday - Friday) as well as any company holidays I may have (Example: July 4th).

    Example:
    6/30/2023
    6/30/2023
    6/30/2023
    6/30/2023
    6/30/2023
    *Skips Weekend*
    7/3/2023
    7/3/2023
    7/3/2023
    7/3/2023
    7/3/2023
    *Skips 7/4 Holiday*
    7/4/2023
    7/4/2023
    7/4/2023
    7/4/2023
    7/4/2023

    Continued until 11/1/2023. And if I needed to include additional company holidays besides the one I provided, how would I include that in the formula?

    Appreciate the help!

  26. How to create excel table to auto fill the dates in one column with the month and Year given in a cell as input and how to high light the weekend days

    Example

    Month and Year 03/2023

    Dates
    01
    02
    03
    04
    05
    06
    07

      1. I want to know is it possible to autofill date in a column of particular month, when the month is provided by the user.

  27. Hi, I am trying to get a formula where i can write the date in one cell then have cells three rows below auto populate the week entirely.

  28. I am trying for Date Sequence With regular interval of blank five columns but Not Working Any Suggestions ?

      1. like for example i am trying for this.....
        March 2, 2023

        March 3,2023

        March 4,2023

        in this way i am trying to do if any thing possible ?

        1. Hi!
          If I understand correctly, write the date in the first cell. Select that cell and the empty cell below it. Hover the mouse cursor over a small square at the lower right-hand corner of the selected range. Hold and drag the fill handle down the column.

  29. Hello,

    can anyone help me with a formula for the following:

    Tuesday, February 28, 2023 AM
    Tuesday, February 28, 2023 PM
    Wednesday, March 01, 2023 AM
    Wednesday, March 01, 2023 PM
    Thursday, March 02, 2023 AM
    Thursday, March 02, 2023 PM
    Friday, March 03, 2023 AM
    Friday, March 03, 2023 PM
    Saturday, March 04, 2023 AM
    Saturday, March 04, 2023 PM
    Sunday, March 05, 2023 AM
    Sunday, March 05, 2023 PM
    Monday, March 06, 2023 AM
    Monday, March 06, 2023 PM

    and etc....

    Thank you in advance

    1. Hello!
      Write in the first cell the starting date and time, for example, 1.03.2023 01:00:00 In the next cell add to this value 0.5: A1+0.5 Copy down the column. Use a custom date format
      dddd, mmmm dd, yyyy AM/PM
      I hope my advice will help you solve your task.

  30. Till now, the autofill of sequential dates has worked, but suddenly it doesn't anymore. Is there a setting or something that blocks the autofill feature?

    1. Yes I have the same issue since a couple of weeks, haven been searching everywhere. It's NOT the options as you read everywhere... but no autofill anymore for numbers and dates, I presume since one of the recent updates ?

  31. I want to fill a row with the days of week. Cell 1 1/1/2023-1/7/2023 then rack cell on row after that the next calendar week... 1/8/2023-1/14/2023,1/15/2023-1/21/2023, etc

    1. Michelle,

      I'm looking to do something similar but couldn't accomplish using the options described here. Were you successful? Thanks!

  32. Hello,

    Looking to create a table where the same date is listed for that week and then adds 7 days for the next set - I.E

    12/14/2022
    12/14/2022
    12/14/2022
    12/14/2022
    12/14/2022
    12/21/2022
    12/21/2022
    12/21/2022
    12/21/2022
    12/21/2022
    12/28/2022
    12/28/2022
    12/28/2022
    12/28/2022
    12/28/2022

      1. Hi,
        Looking to create a table where the same date is listed 3 times for one day, then sequence for 1 year

        01/01/2024
        01/01/2024
        01/01/2024
        02/02/2024
        02/02/2024
        02/02/2024

  33. Hi Guys,

    Would anyone know how to autofill date on every let's say 50th row? So if I have 19/12/2022 in A1 and want to autofill 20/12/2022 in A50. Is there an easy way of doing this? I know you can drag the date down with a mouse and select a row on which you want to autofill the next day but I would have to do it 365 times.

    Any feedback much appreciated.

    Thank you.

    1. Hello!
      Create a start date using the DATE function and add a sequence of numbers. If I understand your task correctly, try the following formula:

      =DATE(2022,12,19) + CEILING(SEQUENCE(365,1,1,1)/49,1)-1

  34. So I have a set of dates for Mondays.

    Is it possible to change / update the first cell sequentially like every 4 weeks?

    For example:

    Mon, 21 Nov 22
    Mon, 28 Nov 22 (+7)
    Mon, 5 Dec 22 (+14)
    Mon, 12 Dec 22 (+21)

    I'm trying to automatically change Mon, 21 Nov 22 every 28 days

      1. Sorry, I guess I wasn't clear. To give context, I'm using =Today()-Weekday(Today())+2 to determine the Monday for the current week.

        So for this week it is Mon, 21 Nov 22

        I'm trying to auto update this cell because a cycle takes 4 weeks or 28 days to renew. If I leave it as is, the date will update weekly and that will mess with the assignments for the other set dates since the cycle hasn't been completed.

        Assume A,B,C,D are people. Each week there are tasks assigned only for column 1 (they mentor a specific team member in column B).

        A,B,C - D - Mon, 21 Nov 22
        A,B,D - C - Mon, 28 Nov 22
        A,C,D - B - Mon, 5 Dec 22
        B,C,D - A - Mon, 12 Dec 22

        I hope this makes sense, if its not possible it's fine. Was worth asking / trying. Thanks

  35. I need to create a sequence for attendance period from 26th of current month to 25th of subsequent month. I am mentioning from date in cell "A2", then providing equation in cell "B5" as "=A2" and setting custom format to "DD". Cell "C5" to "AF5" equation is set "+1". Let's say A2 is 26/10/2022, hence B5 is 26 and AF5 is 25. if I change date in A2 to 26/11/2022, AF5 will be 26 in this case. Since it crosses attendance period of 25th, AF5 should become blank. Please guide what excel formula will help this scenario.

  36. Hello
    I would like to know how I can create a formula with a sequence of 4 days in and 4 days out, including weekends. Thank you

    1. Hi!
      If I got you right, the formula below will help you with your task:

      =WORKDAY(A1-1, TRUNC(MOD((SEQUENCE(100,1,1,1)-1)/1,4)+1) + (CEILING(SEQUENCE(100,1,1,1)/2,2)-2)*4)

  37. Hello!

    If you can help me, please. I have to generate for every month a sheet with 19-25 (25 week days and 19 in weekends) intervals per every day, from half to half a hour, start from 8:00 AM and end at 8:00 PM in week days and in weekend start from 9:00 AM and end at 6:00 PM.

    EX: 10/9/22 is Friday and 10/10/2022 is Saturday
    10/9/2022 12:00 PM
    10/9/2022 12:30 PM
    10/9/2022 1:00 PM
    10/9/2022 1:30 PM
    10/9/2022 2:00 PM
    10/9/2022 2:30 PM
    10/9/2022 3:00 PM
    10/9/2022 3:30 PM
    10/9/2022 4:00 PM
    10/9/2022 4:30 PM
    10/9/2022 5:00 PM
    10/9/2022 5:30 PM
    10/9/2022 6:00 PM
    10/9/2022 6:30 PM
    10/9/2022 7:00 PM
    10/9/2022 7:30 PM
    10/9/2022 8:00 PM
    10/10/2022 9:00 AM
    10/10/2022 9:30 AM
    10/10/2022 10:00 AM
    10/10/2022 10:30 AM
    10/10/2022 11:00 AM
    10/10/2022 11:30 AM
    10/10/2022 12:00 PM
    10/10/2022 12:30 PM
    10/10/2022 1:00 PM
    10/10/2022 1:30 PM
    10/10/2022 2:00 PM
    10/10/2022 2:30 PM
    10/10/2022 3:00 PM
    10/10/2022 3:30 PM
    10/10/2022 4:00 PM
    10/10/2022 4:30 PM
    10/10/2022 5:00 PM
    10/10/2022 5:30 PM
    10/10/2022 6:00 PM

    I hope it's posibile :(
    Thank you verry much!

    1. Hi! :)

      I've tyried something, that works, but not completly well. I cant SEQUENCE the SEQUENCE :)) (if it's posible). If i modify the start date all is good, but i need to populate the sheet with all days :(, not one by one.

      My formula " =IF(WEEKDAY(R1,2)<6,SEQUENCE(25,1,DATE(YEAR(R1), MONTH(R1), DAY(R1)),0)+SEQUENCE(25,1,TIME(8,0,0),1/48),SEQUENCE(19,1,DATE(YEAR(R1), MONTH(R1), DAY(R1)),0)+SEQUENCE(19,1,TIME(9,0,0),1/48)) "

      in R1 is the date 10/1/2022

      Thank you.

  38. Hi, i wanna ask if a database as > | 28-Apr-22 | 29-Apr22| 2 | = |[from date]|[to date]|[number of day]|, can we seperate the date into 2 database in excel?

  39. I am creating a workbook and my raw data tab has numerous groups names that I need to assign the same DOW. I then want the same number of cells for the next DOW. How can I auto generate this without having to copy and paste.

    I.E.

    Sunday
    Sunday
    Sunday
    Sunday
    Monday
    Monday
    Monday
    Monday
    Tuesday
    Tuesday
    Tuesday
    Tuesday

  40. I want to make function to make numerical series in column a:a based on entered values in column b:b
    the condition is when the values repeated in b:b the the series in a:a takes the same value else complete series
    ex

    a b
    1 20
    2 41
    3 45
    3 45
    4 64
    5 69
    5 69
    6 75
    7 77

    1. Hi!
      If the values in column B are sorted in ascending order, then in A1 write the number 1, and in A2 write the formula

      =--(B2<>B1)+A1

      After that you can copy this formula down along the column.

  41. Trying to autopolulate dates that are two weeks apart. Please help!

    This is examples of what I would like it to look like.

    01-02-22 to 01-15-22
    01-16-22 to 01-29-22
    01-30-22 to 02-12-22
    02-13-22 to 02-26-22
    02-27-22 to 03-12-22
    03-13-22 to 03-26-22
    03-27-22 to 04-09-22
    04-10-22 to 04-23-22
    04-24-22 to 05-07-22
    05-08-22 to 05-21-22
    05-22-22 to 06-04-22

  42. i need to insert value USED start date TO end date used pick date in excel
    exempt the value pick date 01/01/22 to 04/01/22

    01/01/22 I USED
    ______________________
    02/01/22 I USED
    _____________________
    03/01/22 I USED
    ______________________
    04/01/22 I USED
    ______________________
    05/01/22 I
    ______________________
    06/01/22 I
    .
    .
    .
    .

  43. Exciting new feature and thank you for the breakdown. Do you know if there is a way for excel to acknowledge historical dates? My Date column will format appropriately for 1900+ dates but pre-1900 dates don't convert past YYYY-MM-DD. Am I doing something wrong? Or has Microsoft not yet integrated this feature for us history buffs?

  44. Hello - great article! Just wish my brain could grasp some things. Thanks so much time for posting - sincerely appreciate.

    I need the following. Hopefully it can be done.

    6 of same date for a Monday
    4 of same date for a Tuesday
    6 of same date for a Wednesday
    4 of same date for a Thursday
    6 of same date for a Friday
    6 of same date for a Saturday
    0 (skip Sunday)

    Repeating through the end of the year.

    It can start on January 1, 2021, which is a Friday, if that makes it easier. Or, can add a Sunday if that's easier. I wouldn't need it to say the day next to the example below, the day is just provided for example of repeating pattern.

    Below would be example:

    1/4/2021 Monday
    1/4/2021 Monday
    1/4/2021 Monday
    1/4/2021 Monday
    1/4/2021 Monday
    1/4/2021 Monday
    1/5/2021 Tuesday
    1/5/2021 Tuesday
    1/5/2021 Tuesday
    1/5/2021 Tuesday
    1/6/2021 Wednesday
    1/6/2021 Wednesday
    1/6/2021 Wednesday
    1/6/2021 Wednesday
    1/6/2021 Wednesday
    1/6/2021 Wednesday
    1/7/2021 Thursday
    1/7/2021 Thursday
    1/7/2021 Thursday
    1/7/2021 Thursday
    1/8/2021 Friday
    1/8/2021 Friday
    1/8/2021 Friday
    1/8/2021 Friday
    1/8/2021 Friday
    1/8/2021 Friday
    1/9/2021 Saturday
    1/9/2021 Saturday
    1/9/2021 Saturday
    1/9/2021 Saturday
    1/9/2021 Saturday
    1/9/2021 Saturday

    Thanks.

  45. Hello, I need to auto fill Column A with a pay period date range and type in a formula to get the next date range so I don't have to manually type the next pay period for the next year. Some dates have already been entered above so I am on line 190. I typed my date range 3/6/22-3/12/22 and went down to A191 and typed in A191+7 like you suggested above but I get a value error after hitting enter. Can you tell me how to achieve this? I want it to look like this below without manually entering the pay periods for the next year.
    Column A
    3/6/22-3/12/22
    3/13/22-3/19/22
    3/20/22-3/26/22

    1. Hello!
      Your date range is text. You can get it by merging cells. In these cells, you can create a sequence of dates =A1+7 and =B1+7
      I hope it’ll be helpful. If something is still unclear, please feel free to ask.

  46. HI
    I want to creat a spreadsheet that will increment the dates i.e. 24/2/2022 to 2/3/2022, but the following week I only want to change the first date and the spreadsheet automatically change the following dates.

    Im struggling to make this happen at present

    any help appreciated

    Thank you

    1. Hello!
      To create a date sequence, write the date in the first cell and add 1 to that date in the next cell

      =A1+1

      After that you can copy this formula down along the column.

  47. Hi,
    I'm trying to create a list of due dates based on a target end date. So I want to calculate 4 weeks before a date, 3 weeks before, 5 days before, etc. I can find gantt charts that create based on a start date, but nothing based on an end date.
    Thank you.

  48. Hi,

    Thank you for the tips. I would like to create a sequence of 3 working days per week, say Tuesday, Thursday and Friday. How do I do that?

    Many thanks

  49. I need help with date sequence. I have 4 units I make a day. 20 units each week. Skipping wknds. I would like to know as my list grows of units how far the date will be.
    1 2-7-22
    2 2-7-22
    3 2-7-22
    4 2-7-22
    5 2-8-22
    6 2-8-22
    7 2-8-22
    8 2-8-22
    And so on and so on. Is there a way of doing this?

    1. Hello!
      Please try the following formulas:

      =SEQUENCE(100,1,1,1)

      =DATE(2022,2,6)+CEILING(SEQUENCE(100,1,1,1)/4,1)

      You can learn more about SEQUENCE function in Excel in this article on our blog

  50. Hi! I am trying to create a formula on a workstream tracker where the end calendar date for a task will automatically populate based on the start date entered and another column showing the number of workdays a task takes. Can a formula be customized to do that? Thanks for any insight!

Post a comment



Thanks for your comment! Please note that all comments are pre-moderated, and off-topic ones may be deleted.
For faster help, please keep your question clear and concise. While we can't guarantee a reply to every question, we'll do our best to respond :)