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.
Thanks a lot for your help,
Reviewing the attached excel file I was unable to understand what is the desired result. What are the last 3 columns on the desired output tab calculating?
Cheers, Byrne, Patrick