Vba to gray out weekends when dates are seperated.

[LOZ1962]

I have a year to view calendar,in a grid format 31 days accross the top & months down the a: column I would like to use VBA to grey out weekends. I have tried every formula I can find with very limited success as they do not know what year or month it is. They grey out days 6/7 in all months.. 4 days I've been trying to do this Thanks for looking & any help given. Regards Loz Baker (58 years old & still learning.)

 

[Fluff]

In that case just use

=DAY(EOMONTH(DATE($A$2,MONTH($A3&1),$B$2),0))<B$2

 

[LOZ1962]

In that case just use

=DAY(EOMONTH(DATE($A$2,MONTH($A3&1),$B$2),0))<B$2

Thank you so much, I am sure I tried that variation from the earlier formula with no success. thanks again.

 

[Fluff]

You're welcome & thanks for the feedback.