Forum Discussion
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
------------------------------