sum product with conditional start date and end date / end date blank failure

Hello Community, I have a block from which I can't get out....

I am using the formula sumaproduct to get the data of the sheet Absences with its first day and its last day, the problem I get when in the last day data there is no date, it is understood or it could be calculated with the formula today() to give you a data. The question is that when there is no date, the summaproduct that I have made adds up the total of days and even in a month that there is no initial or final date.

How can I solve it?

Thank you very much

Administrative Note:

It has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here. I will add them for you today: https://www.excelforum.com/excel-fo...date-and-end-date-end-date-blank-failure.html and https://www.mrexcel.com/board/threa...-and-end-date-end-date-blank-failure.1170422/

Read this to understand why we (and other sites like us) consider this to be important.