Hi all.

Excel noobie here. I need your help please.

I am wanting to create a excel, which displays one worksheet for each month of the year - January to December.

And in each worksheet, for example January, should automatically display (just like a calendar) every day of this month.

I would like to have a blank cell under each day, which I can add a value of 0 or 1 and have a weekly total. I would also like to have a monthly total displayed somewhere.

I have been doing some reading and I believe Macros will be needed for this project.

Can some kind folk help me just to get started please?

Thank you.