Thank you for pointing that out. I based the holidays on a list from the company where I worked at the time, and they didn't take that one off. It would be easy enough to add the code for that.

After MLK Day, insert:

--President's Day (3rd Monday)

([Month] = 2

AND [DAY_OF_WEEK] = 2

AND DATE_ID IN (SELECT

MIN(DATE_ID) + 14

FROM

DATE_DIM

WHERE

[Month] = 2

AND [DAY_OF_WEEK] = 2

GROUP BY

[Year])

)