I would like a have a simple solution for the problems attached. In the first Excel tab (Input), I have start date and end date of events (eg A,B). And in the second tab (Desired_Output), Duration of each day of these events has been shown. I just have provided an example set, but practically the data is spreaded over more the 3 days. I was trying to do some calculation like DATEDIFF but seems like pivoting all of the dates is bit difficult.
Please let me know any further clarification is needed.