Calculate Federal Holidays into Due Date
Hi All, I have a calculated due date field that counts from a numeric length. The formula takes into account the current date, or any date input into a date field, and then adds the numeric length...
Forum Discussion
There looks to be multiple solutions posted here but I cannot speak to how they work. It will depend how far out you need to look for holidays though from what I understand.
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=cad6859e-aafe-4479-9521-6fe960374e5a&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer
-------------------------------------------
https://getsatisfaction.com/quickbase/topics/exclude-holidays-and-week-ends-in-total-days-calculation
There is also this one but the links are broken in most of it. You might be able to get the archives through Google or Archive.org, they may or may not help. I would try searching for the full URL they posted. Google might find it and then click the little down arrow next to the link and choose "cached" and it will work. You may need to search for only partials of the URL, this is more of a process you just have to go over.
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=cad6859e-aafe-4479-9521-6fe960374e5a&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer
-------------------------------------------
https://getsatisfaction.com/quickbase/topics/exclude-holidays-and-week-ends-in-total-days-calculation
There is also this one but the links are broken in most of it. You might be able to get the archives through Google or Archive.org, they may or may not help. I would try searching for the full URL they posted. Google might find it and then click the little down arrow next to the link and choose "cached" and it will work. You may need to search for only partials of the URL, this is more of a process you just have to go over.