Forum Discussion

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

Re: Calculate total working days between dates (including Bank holidays)

Re:

excluding the holidays would be a simple matter of ....

Actually, this is actually not an easy problem to solve using formuals. Al other solutions I have seen and implemented myself are not elegant and involve tons of code and formulas.

i

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

6 Replies

StuartKemp
Qrew Member
5 years ago
Hi Mark & Paul,
Thank you.
With some help we have tackled the first challenge by using two automations to and from for the relevant date range and it counts correctly.
Now on to the challenge of returning the resulting date after adding X amount of working days depending on Weekends, Bank & Company Holiday fall within the amount of days.

------------------------------
Stuart Kemp
------------------------------
- MarkShnier__You
  Qrew Legend
  5 years ago
  You first post suggested that you wanted to calculate the # of working days between two dates. Are you now asking a different question - to calculate the end date given the start date and the # of working days required?
  
  ------------------------------
  Mark Shnier (YQC)
  Quick Base Solution Provider
  Your Quick Base Coach
  http://QuickBaseCoach.com
  mark.shnier@gmail.com
  ------------------------------
  - StuartKemp
    Qrew Member
    5 years ago
    My first post was a two parter, sorry I merged them together.
    a) Calculate the number of working days between two dates (including Bank Holidays etc) - now resolved with help and automations.
    b) Calculate an end date by adding the number of working days to a start date (including Bank Holiday etc) - still trying to get my head around as the end date will then be a of a moving target depending on when the Bank Holiday etc fall.
    
    ------------------------------
    Stuart Kemp
    ------------------------------