Automatic Hiding of Columns in Excel based on Moving Dates

Automatic Hiding of Columns in Excel based on Moving Dates

I am not a coder, but would appreciate some help in trying to hide columns
in excel when a condition is met. I am trying to create a monthly rolling
view of certain columns as time passes. I have weekly dates in each column
header. So I only want to view columns with dates 6 weeks ahead. I would
like past weeks and weeks more than 6 weeks ahead to be automatically
hidden. Is there any easy way to code this in VB? I believe some type of
if/then and loop would do the trick, but I haven't had any luck building
the code myself. Thanks for the help!