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 to that to calculate the final due date field. This takes into account days/months/or years. It currently does not take into account workdays, which I think is an easy fix with ToWeekdayN and isWeekday formulas, but what we cannot figure out is how to calculate if any days within the time period that is being calculated is a federal holiday. Our first thought was to create a Federal Holiday table, and do a query to run through all of the dates. Any ideas on how we could accomplish this?
------------------------------
Ursula
------------------------------
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 to that to calculate the final due date field. This takes into account days/months/or years. It currently does not take into account workdays, which I think is an easy fix with ToWeekdayN and isWeekday formulas, but what we cannot figure out is how to calculate if any days within the time period that is being calculated is a federal holiday. Our first thought was to create a Federal Holiday table, and do a query to run through all of the dates. Any ideas on how we could accomplish this?
------------------------------
Ursula
------------------------------
