Date Calculation Formula excluding weekends and bank holidays

Hello - I need some guidance. I used this formula to calculate weekly, bi-weekly, monthly, bi-monthly, quarterly, bi-quarterly, annually, bi-annually dates and then I realised I need to exclude weekends and ideally bank holidays.

The weekly and bi-weekly were easy but now I'm stumped🤪 on the monthly, bi-monthly, quarterly, annual, bi-annually. I know simply adding on an extra 30, 60, 90 days isn't the Smart way to execute the task. Some guidance (a solution😏) would be appreciated. Here's an example of the fields I'm using

=[Confirmed Comms Send Date]@row + 14 and I added WORKDAY to the start of the formula and it worked for the 7 and 14 days but not for the monthly etc., =WORKDAY([Confirmed Comms Send Date]@row, +7)

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!