Generating Calender Automatically

Hi,

I've programmed access using VBA before but not excel. I'm lost and duno where to start. This is what I intend to do:

To program a system to let users know if a resource is being book. So I would have current month in 1 row, and the day of the month in another row something like this


May (current month)
1 2 3 4 5 6 7 8..... 31 (days of the month)
sun sat mon tue wed (week of the day)
Resource 1
Resource 2
Resource 3 ....

I want the excel file to dynamically generate a sheet (calender with the resource) for each month and delete the old sheet. How feasible is this? Should I use macro? VBA? or combination of both? Many thanks for any advice.

Hi,

I want to add a macro such that for a month with 30 days select 30 columns, 31 days select 31 days, feb select 28/29 columns depending if its a leap year..any advice on how to do it? Thanks for any advice!