Forum Discussion

BrettTelford's avatar
BrettTelford
Qrew Member
10 years ago

Calculate duration excluding weekends, dependent fields are date/time formatted, present result in hours.

Here is the formula that I have now, that works, that is not excluding weekend days: ToHours(If([Task Status]="Completed",[Deadline]-[Time Completed],[Deadline]-Now())) Here is what I tried t...
Forms
Formulas and functions
Relationships
KevinO_Boyle's avatar
KevinO_Boyle
Qrew Cadet
8 years ago
I've been looking for a solution to the Excel equivalent of the networkingdays() function and this is it.  Probably easy for some folks but I'll copy and paste the code in so it shows up in searches.  (In my formula booked date = start date and scheduled date = deadline


var Date StartTime = [Booked Date];
var  Number  NumWeekendDays = ToDays([SCHEDULED DATE] - ($StartTime))  - WeekdaySub ( [SCHEDULED DATE], ($StartTime) );

If([XMF Current Production Schedule Date]>[SCHEDULED DATE],ToDays([XMF Current Production Schedule Date]-[Booked Date])-($NumWeekendDays),ToDays([SCHEDULED DATE]-[Booked Date])-($NumWeekendDays))