Need Help in modifying Holiday Tracker in Excel

**asutosh1729** · 01-26-2012, 04:09 AM

I am trying to use the holiday tracker mechanism, whereby, one user can enter the start date and end date of the holiday period he/she wants to choose and then choose the type of leave "sick/vacation" etc.

By choosing the above 3 inputs (start date, end date and type of leave), I want to auto-populate a calendar containing entire year dates.

Example:
If John enters 03/12/2012 to 03/27/2012, and type of leave as "Sick leave" then, in the calendar, I would be able to see all dates within 03/12/2012 and 03/27/2012 marked in a specific colour and marked as Sick. This can be extrapolated to all other employees.

Please do reply, if there would be any idea, pointers or existing work related to this.

Many thanks and Regards,
Asu

**dilipandey** · 01-26-2012, 04:42 AM

Hi Asu,

Welcome to the forum.

If the dates would be marked in specific colour.. then where do you want to mark them as sick.. is it the next column or do you want some color which will denote sick leave..?

Regards,
DILIPandey

<click on below 'star' if this helps>

**asutosh1729** · 01-26-2012, 04:53 AM

Hi Pandey Sir

Marking as Sick is not an important, as long as the days within the dates input, are marked in the calendar in some specific colour.

Can you give some pointers and/or existing reference to this?

Thanks..
Asu

**dilipandey** · 01-26-2012, 05:41 AM

Hi Asu,

Not sure what type of format you are looking for in the results... but try using following formula in column B and drag it down.. It assumes the start date in A1 and end date in A2. Thanks

Please Login or Register  to view this content.

Regarding colors for leaves.. I would need leave types and their respective colors.

Regards,
DILIPandey

<click on below 'star' if this helps>

**asutosh1729** · 01-26-2012, 05:41 AM

Hi Friends

Is there any reference in this forum related to the query, as I found few threads which have some pointers, but not similar to the query I am having.

Regards
Asu

**asutosh1729** · 01-26-2012, 05:56 AM

Hi

When I am using the formula currently it shows blank.

How do I link your formula to a calendar to autopopluate the days? (not the number of days, but the actual days in the calendar)

I want to auto-populate as Sick leaves as yellow, vacation as green, and personal leaves as "brown".

Thanks
Asu