Hi,
I have to count the days between two dates, which I can do. But I need to count only the days that fall between those dates but only if they fall between another pay period date range.
Example in first row "Employee 1" if I have a staff member on leave from 25/11/19 till 06/12/19 but I need to count how many days between that range but only if they fall between pay period 02/12/19 - 08/12/19 (Inclusive) I would expect a result of 5 days with the correct formula. It should count 2nd, 3rd, 4th, 5th and 6th as days.
I have tried lots of different formulas and just cant get the result I need
Can anyone help please? Example attached spreadsheet with wrong formula.
I just know if this is actually possible??
Thanks in advance
Bookmarks