Forum Discussion

AndrewDay's avatar
AndrewDay
Qrew Member
10 years ago

Calculating duration between two date fields but working days only?

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.

Formulas and functions
Tables and fields

11 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    10 years ago
    No problem, there is a function for that as a formula-numeric field.


    WeekDaySub([start date],[end date])
    • AndrewLandry's avatar
      AndrewLandry
      Qrew Trainee
      5 years ago
      I've tried this but I get "Expecting date but found workdate". Any ideas?
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      5 years ago
      Please post your current formula.

      But basically your fields are work dates and you need to convert them to date using the ToDate function.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    5 years ago
    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's avatar
    AndrewLandry
    Qrew Trainee
    5 years ago
    Thanks Mark but I got the "Expected duration but found number" message
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    5 years ago
    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's avatar
    AndrewLandry
    Qrew Trainee
    5 years ago
    maybe i just need to change the workdate to regular date. I'll give that a try. thank you Mark