Calculating duration between two date fields but working days only?

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered

Hi,

I need a formula that calculates the duration between two date fields but only counts working day (Monday through Friday) and not just the total number days.

So for example;

01-Apr-2015 to 07-Apr-2015 - Normal total duration formula would display result as 6 days but I require it to show just 4 days for this example.

Thanks in advance for assistance.

Photo of Andrew

Andrew

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,268 Points 50k badge 2x thumb
No problem, there is a function for that as a formula-numeric field.


WeekDaySub([start date],[end date])
Photo of Lee Gilmore

Lee Gilmore

  • 790 Points 500 badge 2x thumb
Very helpful, thanks!