Dynamic Excel Calendar

[dolphin_m70]

hello
I have Excel 2002. I am trying to design a dynamic work calendar. I am not an expert in programming so need some help.
where i will input the

1. Start and end time for work (eg: 7:30- 12:30) with the total hours worked displayed in this eg its 5 hrs.
2. My Job no (eg. 550) and date.
3. Also there should be an option for Selecting a date as annual leave or rest day or none of both.
4. Once the above details are inputted, excel should output a dynamic calendar for every month.
5. Different days are color coded ( eg: white - normal day, blue- rest day,pink - annual leave, brown - rest day work)

The calendar should look like the one attached, when generated. Any help would be highly appreciated

thanks

[dolphin_m70]

Anybody pls
Thanks

[dolphin_m70]

This is the dynamic calendar code i am trying to work on which i found on the net. it does the job but there is a slight hitch. its higlighted in red in the code

Please Login or Register  to view this content.

What i am having trouble is the last day of the month. i am using excel 2002.
Could anyone suggest how can i do that, bcoz i tried EoMonth function and it didnt work (marked in red above code).
Also can anyone suggest how i can input data in to the cells after the date using a form attached in my previous post.

thanks

[HerryMarkowitz]

Hi,
There are a lot of excel template for calendar.
Regards.

http://office.microsoft.com/en-gb/te...x?qu=calendars