Excel - count days between two dates per year

Question

I'm attempting to determine how many days there are in a year between two dates.

The outcomes ought to resemble this image in some way.

The range between the 2 dates in the 2021 year has 301 days and in the 2022 year has 94 days.

Answer 1

Put this in C2 and copy over:

=MIN(DATE(C1,12,31),$B$2)-MAX(DATE(C1,1,1),$A$2)