Formula for adding dates to a Calendar

Hi all,

I posted earlier in the week relating to this same worksheet I am working on. I eventually thought it was finished but I now find a have a problem...if I input more than one leave period for an employee, for each period (ie: JAN JUN), this does not show on the corresponding Jan Jun/ Jul Dec sheet (Calendar)

Data inputted in Sheet "EmployeeData" (Note CTRL-Z brings up calendar for inputting dates)

2 sheets - "JAN JUN" & "JUL DEC" use VLOOKUP functions (from BQ4 - BS603 EmployeeData) where I have a representation of leave taken. Notice only one period in each, where-as 2 for each inputted...

Please see the workbook attached for more info.

If I am using the wrong function I will change the title for this thread once I know, for future ref.

Best regards and thanks in advance for your time.

Warren...ultra novice but learning!