Calculate Overlapping Leave for categories

[dineshiam]

Hi,

Could you please help me with a formula.

I need to calculate overlapping leave on each day for particular categories.

I have attached sample data.

For eg; In sample data, there are 2 teachers on leave on 1 July, so I need to get 2 under 1 July in the sheet.

Thanks.

[alansidman]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...ategories.html