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.)