Recurring Date to Fall on Specific Day


Hi -

I've set up two columns "Cadence" and "Launch Date". For the top row of my sheet, I've listed the start date of the month (i.e. November 2) under the Launch Date for formula purposes.

From there, on another row, I have a task where it should be completed 3 weeks after the start date of the month, but fall on a Friday.

The current formula =[Launch Date]1 + Cadence23 works well (and leads me to November 23), but the date falls on Tuesday, where I need it to fall on a Friday.

Any idea how to adjust the formula?



Best Answer


  • Jessica Zell

    That worked perfectly, THANK YOU Leibel!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!