Calculating Holidays

[jman_66]

I am adding to an existing DB. Made the following expression in one field to calculate the date used from another field:

=DateSerial(Year([DATE RROF RECEIVED BY HUD]), Month([DATE RROF RECEIVED BY HUD]), Day([DATE RROF RECEIVED BY HUD])+17)

Any suggestions how I could get this same field to add 18 days, if the date were to fall on a holiday?

Would I use the day of the year? as in #120404#, or would I use the number of the day...as in Veteran's Day is day 315 of the year?

 

[Liv Manto]

Create a table of holidays because some holidays change date.

Then create a query if those dates are in between your dates, count them.

so say if the count is 3 ( 3 dates are holidays) then 17 + 3