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

CONSULTA.png

sorry, I don't know how the web works, thank you very much for your help.

Sorry for not explaining myself well.

In column E [Datos] , I need to get the information that is in the sheet [Ausencias] that is in column D.

When there is no date in column C [Ausencias] that was today's date()
and if the start/end date condition is not met, no value is returned.

Thank you very much for your help

Sorry, in cell E2 the value 14 should appear, in E3 the value 0 and in E4 the value 69.