Auto-calculate a date but round to nearest weekday

SallyJ
SallyJ ✭✭✭
edited 04/20/24 in Formulas and Functions

I a creating a smartsheet that is calculating several milestone dates based on a single event date. This is the formula I'm currently using to calculate a milestone date 8 weeks prior to the event date, based on the event date being manually entered in the [Milestone Date]16 cell. Is there a way to make this return the nearest weekday?

=[Milestone Date]16 - 56

Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!