A working formula to calculate End Date and Time based on Start Date and Time and allocated hours.

Can any one help on getting a formula to calculate End Date and Time based on Start Date and Time and Allocated hours for a Project considering 8 am to 8 pm working hours and excluding Saturday, Sunday and Holidays?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!