Forum Discussion
Business Day Calculation
Looking to do the following calculation in excel
https://www.timeanddate.com/date/weekdayadd.html?d1=27&m1=11&y1=2017&
currently I do
Lead Time / 5 = Lead Time Weeks
Then [Start Time] * [...
Attached the gile. Essentially I would like the on time date to include weekends and holidays (right now I am just including weekends). Moreover I would like TAT to incorporate those as well so that everything lines up.