transfer days from list to calendar format

Hi,

Working on a project to capture Staff Annual Leaves (Vacations) and trying to show a full year report which includes all employees on a column and all working days on a row.

My List is simple looks like

Please Login or Register  to view this content.

And so on.....

And report I am trying to generate is like below;

(TABLE 2) - Starts from A1

Please Login or Register  to view this content.

And so on...

I need show all annual leaves in table 2 as say "F" for full day "H" for half day and blank if no leave taken for the day.

I do not mind doing it with either formula or a vba code but my brain just stopped so cant work out how.

Thanks in advance :-)

I worked out something from another thread.

Hate array formulas but this one looks like working fine.

Still love to get anything better than an array solution.

Formula:

Please Login or Register  to view this content.

Title is a range of result you want to see, start is a range of from date, end is a range of to date, name is a range of employee names and H1 is the date on table 2.