Auto-calculate a date but round to nearest weekday

SallyJ

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!

Paul Newcome

Have you checked out the WORKKDAY function yet?

https://help.smartsheet.com/function/workday

Paul Newcome

Have you checked out the WORKKDAY function yet?

https://help.smartsheet.com/function/workday

SallyJ

Perfect, thank you!

Paul Newcome

Happy to help. 👍️