Statr and End Dates ( 2 Date Fields) In Date Range- Number of Days in a DURATION field

  • 0
  • 1
  • Question
  • Updated 6 years ago
  • Answered
The resulting DURATION yeilds the number of days -are there any QB users who know of a function we can use to eliminate Weekends?

That is, if a start and end data cross over a weekend we only want the Week Days counted.
Photo of Danny

Danny

  • 0 Points

Posted 6 years ago

  • 0
  • 1
Photo of Mark_Shnier

Mark_Shnier

  • 700 Points 500 badge 2x thumb
WeekdaySub([end date],[start date]) will give the number of work days between two dates.
Photo of Danny

Danny

  • 0 Points
Thanks Mark !!!!