Number of days active per year

Hi!

I'm currently having a bad cold, and my brain cannot function 100%, but I need to get some things done before Friday and I'm losing my mind over something that seems simple: having a formula that counts for each year of a given contract, how many days (both normal days and workdays) a site will be open.

Ex:
Contract start-up date 01.09.2018
Site Start-up date End date
A 01.09.2018 31.08.2023
B 01.09.2018 31.03.2021
C 01.12.2019 31.08.2023

Year 1 is from 01.09.2018 to 31.08.2019 (so site A and B get 365 days while Site C gets 0)
Year 2 is from 01.09.2019 to 31.08.2020 (so site A and B get 365 days while Site C gets less) and so on and so forth

I attached an example of what I'm looking for. With my trials included... Oh boy, did I try...

Thanks for helping me!

Kind regards,
Vincent

I had to insert an extra column (yellow). In F5, copied across and down:

=MAX(MIN(F$2,$C5)-$B5,0)-SUM($E5:E5)

and in Q5, copied across and down:

=MAX(NETWORKDAYS($B5,MIN(Q$2,$C5)),0)-SUM($P5:P5)

You're welcome and thanks for the rep.