Fill in staff names next to work dates

[bkjacobs]

Hi there

I have start and end dates for staff, and I would like their name to be shown next to each date they are working (not just the start and end date).

I have attached a simple excel file.

If anyone could quickly help even though it's Friday evening I would be very grateful!

Bruce

[FlameRetired]

Try this in C7 and fill down.

Please Login or Register  to view this content.

BTW: Your Date Out/Date Back inputs are not consistent with your expected results. 'Skipper 1' starts the day after Date Out. 'Skipper 2' includes the Date Out.

[bkjacobs]

Thank you!

[FlameRetired]

You are welcome. Glad to help and thank you for the feedback and added rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.