Hello to all,
I would like some help on a problem I am having when trying to count the number of days between two dates, and then index the number of days for each year.
It is hard to explain so I am attaching a file to better illustrate the problem I am running into. I am basically looking for a formula in the highlighted cells D3:I20 that will show the number of days that are included in each year, from the two dates in columns A and B.
I have tried different formulas with combinations of IF and DAYS formulas, but this exceeds my skills in Excel. Does anybody have any ideas ?
I really appreciate any help/input.
Thank you all,
Bookmarks