Skip to main content
Question

Calculating duration between two date fields but working days only?

  • April 28, 2015
  • 0 replies
  • 261 views

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.

This topic has been closed for replies.

No problem, there is a function for that as a formula-numeric field.


WeekDaySub([start date],[end date])
  • AndrewLandry
  • Registered
  • July 16, 2019
WeekDaySub([Start],[Projected Finish])
I don�t know what field types your two fields are but if they were both work dates, then the formula would be

WeekDaySub(ToDate([Start]),ToDate([Projected Finish]))

Admittedly, working with work dates is confusing.
  • AndrewLandry
  • Registered
  • July 16, 2019
Thanks Mark but I got the "Expected duration but found number" message
I suggest changing your field type of formula in the mirror and then the result would be an integer number of days.

But if you really want it to be in a formula direction field you would have to wrap the formula in Days(......)
  • AndrewLandry
  • Registered
  • July 16, 2019
maybe i just need to change the workdate to regular date. I'll give that a try. thank you Mark
  • AndrewLandry
  • Registered
  • July 16, 2019
you're the best Mark. thank you
Terms & ConditionsAccessibility statement