Auto-calculate a date but round to nearest weekday

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


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!