I'm trying to make a formula for my users to get our Office holiday's on their calendar. We have 7: New Year's Day, Memorial Day, Independence Day, Labor Day, Thanksgiving, the Day after Thanksgiving, and Christmas Day.

The formula I have doesn't quite work and I'm not sure why:

1 Jan(!sun !sat), mon(last) (may), 4 Jul(!sun !sat), Mon(1) Sep, Thu(4) Nov, Fri(4) Nov, 25 dec (!sun !sat)

That is the formula exactly as I have it (spaces and all).

Also with the syntax, I'm trying to make it so that for example if Jan 1 is on a Saturday the date will show up on Friday, and if January 1 is a Sunday, then it shows up on the following Monday. Can I get that specific on this formula? Is that what the ! does?

Thanks in advance!