Help counting leave days

[ShanIre]

Hi All

I'm struggling to figure out a way to count leave days. I need to count the number of annual leave days taken in year one and year two based on the in/out dates and the fact that some of the leave period crossed over the one year mark. See attached example. Hoping someone here can help.

Many thanks.



Capture.PNG

[johnmpl]

Hi, ShanIre!

You can use this formulas:
[C2] : =MAX(,1+MIN(G2,B2)-MAX(F2,A2))
[E2] : =MAX(,1+MIN(I2,D2)-MAX(H2,B2))

Blessings!

[ShanIre]

Great, thank you for the quick reply