Need help excluding weekends in estimated completion date formula
Hello! I am currently working on a Smartsheet that estimates how long a project should take depending on a multitude of variables. So far all my formulas are working great, but I am using the following formula to determine an estimated project completion date:
This formula is unfortunately accounting for weekends as well, and I'm hoping someone has a solution where the estimated completion date would only account for dates MondayFriday.
Thanks!
Answers

Hello @joemagal
Try this
=WORKDAY([Start Date]@row, [Total Dev Time (Days)]@row)
Will this work for you?
Kelly

Hey Kelly,
Thanks for your help with this. That formula does work for most cells, but some are showing #INVALID DATA TYPE and I cant figure out why... I changed the decimal system in the Total Dev Time row to show only whole numbers hoping that would make it easier for Smartsheet to calculate the date but no avail. Any ideas?
Also, if "Start Date" is left blank, "Estimated Completion Date" also shows INVALID DATA TYPE. Is there a way to change this so if Start Date is left blank, Estimated completion date is also blank?
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!