I recall seeing a nice post by a Quick Base staffer about this which was the most elegant solution so far, but I can't locate it.
The gist of it is here
You already have your Master Holidays Table. Create a child table to your "Projects" table called Project Holidays.
Set up an Automation that when a record is added or modified
1. Delete the Project Holidays (ie in case the Projects dates are modified we need to start fresh)
2. Copy the Holidays from the master Holidays table (just the ones flagged as Holidays) to the Project Holidays table where the dates meet the Project dates.
3. The count of those children is the # of holidays in the Project date Span.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
