Hi to all,

I have a problem with orverlapping dates in range.

I have a list of employees absences (some starting / ending in one month, others not)
I need to find out how many days of absence each employee had in each month

I already tried to use standard formula (max(min(end,end)-max(start,start)+1,0)) but it works only for one record (I can have multiple rows for one employee)

Please do you have any idea, how to solve this (just for info: there is no chance that the dates of one employee will overlap (if there are multiple records per employee)

Overlapping dates in range.PNG

thank you very much for any advice.

Mike