Date Sequencing

Hello. Can someone please help? I'm trying to auto insert/sequence a series of dates between two different dates in two different cells. If Date1 is 1/15/24 and Date2 is 2/8/24 Id like a third cell list the two dates and all dates in between on individual consecutive rows.

Answers

  • Michelle Choate 2
    Michelle Choate 2 ✭✭✭✭✭✭

    I am not certain that there is a way to do this natively inside of Smartsheet. There are zero formulas that I can think of. You might have to go to an exterior program to perform this action.

    Michelle Choate

    michelle.choate@outlook.com

    Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!