Time off from List to Timeline

Dear Community, here is the case:

I just inherited a team of 15 people who are used to input their time off in an excel sheet with 3 columns: Name, Start Date, End Date. My idea is to create a Timeline from that. The issue I'm having is that a user can have more than one record for time offs.

I've found a couple of formulas online for the timeline. The problem I'm having is that names repeat multiple times in the time off sheet. For example someone can have a couple of day offs in June and some more in July.

So, my idea is to have a timeline with unique names and all days off for that person.

I've attached what I have so far.

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Try this in Timeline C2 and copy down and across.

Formula:

Please Login or Register  to view this content.