Hide and Unhide Excel columns based on Date

Hi all,
I looked for an answer to this on this forum and tried running some of the VBA code I found, but I think I'm too dense to know how to modify as I was unable to make it work. I was hoping someone may be able to assist. I think it's a very simple problem but I can't seem to solve it.

I have a Today's Date in A2. I have two weeks' worth of dates in B2-F2 and then H2-L2. I want to unhide columns with any dates before and including Today's Date and hide columns with future dates after Today's Date.

Any assistance would be greatly appreciated!
Thanks!

We can help you better if you can upload an example file as described in the yellow banner above.

Yes, sorry about that. Was hoping to get by without that. My IT department won't allow us uploading any company files...even if a dummy Worksheet. They won't tell me how to do this, but they can tell me not to upload of course! I'm hoping a screen shot of the data will help? Thank you for your understanding.

Try these code modules

Please Login or Register  to view this content.

This worked maniacb!! Awesome!! Thank you so much! Just one small question, when I ran the first module, it took away this entire week, including today. Is there an issue with having "<=" beside one another?

Again, thank you for the assistance! This is fantastic.

The code only looks at ranges B2:L2. The "<=" will hide todays value in that range.

I got it to work! This is excellent maniacb. Again wanted to thank you for your assistance! You are a great resource!