Populate cells if there is a MIN & MAX value

[coach.32]

If I have a staff member that takes leave from 4-01-2014 to and including the 15-01-2014, is there any way I can
populate the 2 mentioned cells and the cells in between. I have attached an example spreadsheet - Sheet 1 contains the Staff
Member's name, the date they have chosen to start their leave and the date they wish to finish. On sheet 2 I have manually filled in
each day the staff member will be on leave. I'm just wondering if there is a way Excel will automatically fill in the fields for me. This
will help me in completing other stages of my Staff spreadsheet. Thank you for any assistance you can offer.

[azumi]

Fix it coach, pls check the files


Azumi

[coach.32]

My apologies - File updated

[benishiryo]

try this in B2:
=IF(COUNTIFS(Sheet1!$A:$A,$A2,Sheet1!$B:$B,"<="&B$1,Sheet1!$C:$C,">="&B$1),"On Leave","")