Return Work Dates between start date and end date


I have 2 columns, [Start Date] and [End Date] on my sheet. I want to fill another column [All Dates] with all dates between and included start and end date. So if: Start Date - 8/24/2020, End Date - 8/28/2020, i would like the return values in a column [All Dates] to be: 8/24/2020, 8/25/2020, 8/26/2020, 8/27/2020, 8/28/2020.

How can I loop through while less than [End Date], then combine using Join.


Best Answers

  • David Clemons
    David Clemons ✭✭✭
    Answer ✓

    Created another sheet to reference dates, so your solution worked great. Thanks for the help.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!