Weekly date with manual override

Mark.Hendley ✭✭
edited 12/19/23 in Formulas and Functions

I'm looking to create a formula to have a cell show a date for when our next delivery comes in.

Typically these deliveries are every Tuesday, but sometimes they are late by 1 day, or we skip a week because we don't need it.

I would like a cell to show the next estimated delivery date


Today the cell would show: "TODAY"

Tomorrow the cell would show: "Tuesday, Jan 2 2024" (we are skipping next week)

Again, once the day of delivery is here the cell will show "TODAY" and then the following day will show the next estimated delivery date.

I want to have 2 columns that are override columns, one that changes the date by one day, and the other by a week.

I'm really not sure where to even start with this formula so any insight is appreciated. Preferably an explanation as to how the formula works, so I can learn from it and help others.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!