Auto Hide Columns Based on Day of the Week

[MikeeRDX]

Hello-

Is there a way to auto hide a column if the date is corresponding to a certain day of the week? Say I would like to auto hide a column if the date in that column is a Saturday or Sunday. I'm trying to create a dynamic calendar that will allow me to auto hide dates that fall on a weekend.

Your help is much appreciated.

 

[MikeeRDX]

Sorry for the lack of information. Below is a screenshot of what I hope to accomplish. I would like for columns "G" and "H" to auto hide since they are weekend days.