including weekends & certain holidays into friday (1 Viewer)

hi everyone. fairly new to access and am in the process of capturing retail data where the work day is mon-fri but the weekend and holidays that fall on Mondays like labor day, the number o retails is totaled and considered to be Friday.
I did a few searches and majority of the posts were excluding weekends. i'm thinking one idea is have a table dedicated to holidays that the coding can also look into to include in the calculation. any insight and advice is greatly appreciated!

I see this hasn't received a reply after a week.
So it doesn't get overlooked, I'm posting this to give it a 'bump'.
I've also removed the html tags from your post due to a site glitch.

Suggest you look at the similar threads at the bottom of this page or use the advanced site search tool.

Sorry, i had thought i deleted this thread. I was able to find a solution to my question in another thread. Ill mark this as solved