Leave Planner

[edward91]

i have a pretty tricky senenario here..i have a data dump of employee leave.Containing the name, number of consume day,start day and end date.
i trying to map the them into a "planner"which i cope from internet..
is there any method like vlookup,advance filter,match or index to help me solve?


this is a sample of my raw data

something like if the start date of the employee = the calendar date it will display the LIST of employee whose start date is on tat day..does not need to be a lot just enough to fill up the space in the calendar l
this is how i want it to be

whereby the 2 mean e day consume and apple mean name of the employee

http://www.vertex42.com/ExcelTemplates/excel-calendar-template.html
this is e link whr i dl the calendar template frm

 

[edward91]

Please help me > <

 

[shemayisroel]

Could you please post up an example of how you would want you result to look like - base the resulst off your sample data and perhaps try & exaplain how you came up with them

 

[edward91]

is this more clear? if u dun mind..i can arrange to meet up with u.i pretty despo now > <