Forum Discussion
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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- StuartKemp5 years agoQrew MemberMy 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
------------------------------- MarkShnier__You5 years ago
Qrew Legend
I don't know how to do Part B as that would seem to need to be an iterative process.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - AdamKrzyzanek2 years agoQrew Captain
Any success in achieving this? I saw that for new Gantt Plugin they mange to achieve it and User can specify Holidays days in dedicated table, and Gantt is skipping those days as not working.
I wonder if this is Plugin functionality, or they manage to do it via Native Quickbase formulas?
I am having similar problem to solve to calculate End date of my task based on duration & start Date. But I want to include additional Custom Holidays to this. Additional Challenge is that I need to have different holidays per country, which makes it even more complex😀.
------------------------------
Adam Krzyzanek
------------------------------- MarkShnier__You2 years ago
Qrew Legend
This community post here outlines a somewhat brute force method to calculate the number of holidays in a date span.
There are now more elegant methods using Formula Queries. I will see if I can find an example. .
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------