Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Convert day of month to Business Day date

We have a calendar template that we re-use every month. On this calendar ,we have a column that is the numerical representation of the day of the month (1, 2, 3, 4, etc.). Each month, this is a different date. Currently, someone is manually entering the dates that correspond to the day number.

Is there a formula that would convert 1 to the first business day, 2 to the second business day, etc.?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions