Dynamic Arrays - Count Days

[Leticia]

Hi!! I am traying to sum all the days that has elapsed between the origin date and a fixed given date when some conditions happen to occur.
I copy below a sample.

DATE (A)	SOLUTION (B)
05/05/2021	10/05/2021
10/05/2021	10/07/2021
20/05/2021	20/07/2021
20/05/2021	30/05/2021
25/05/2021

	31/05/2021 (D1)
Days	#VALUE!​

The error I have obtained is from the following formula
=SUM(FILTER(DAYS($D$1;$A:$A);(A2:A77<=D1)*((B2:B77>=D1)+(B2:B77=""))))

I cannot create a complementary column counting the days when this occurs, because of the database I am working with.

Thank you so much!

 

[Fluff]

How about

=SUM(FILTER(DAYS($D$1,$A2:$A77),(A2:A77<>"")*(A2:A77<=D1)*((B2:B77>=D1)+(B2:B77=""))))

 

[Leticia]

How about

=SUM(FILTER(DAYS($D$1,$A2:$A77),(A2:A77<>"")*(A2:A77<=D1)*((B2:B77>=D1)+(B2:B77=""))))

Thank you! I worked!
Also do you know why when I do EDATE(28/02/2021;-1) it gives me back 28/01/2021, instead of 31/01/2021?

 

[Fluff]

It's because 28-Jan is one month before 28-Feb