Days elapsed from start date to finish date

[edge37]

Hi! I need your assistance, please. I want to calculate the difference between a Start Date and the Today’s Date until the Finish Date, ensuring that it doesn't calculate more past the Finish Date. What else could I add to my formula:

=NETWORKDAYS.INTL(B2,TODAY(),1,$E$2:$E$12)

for it to stop counting once the finish date has been reached?

Thank you very much

CUADRO DE NOTAS 2025.xlsm
	B	C	D	E
1	Start date	Finish date	Elapsed days	Holidays
2	3-Nov	5-Dec	21	14-Apr
3				15-Apr
4				16-Apr
5				17-Apr
6				18-Apr
7				15-Sep
8				29-Sep
9				30-Sep
10				1-Oct
11				2-Oct
12				3-Oct
Sheet1

Cell Formulas
Range	Formula
D2	D2	=NETWORKDAYS.INTL(B2,TODAY(),1,$E$2:$E$12)

 

[Cubist]

Try:

=NETWORKDAYS.INTL(B2,MIN(C2,TODAY()),1,$E$2:$E$12)

 

[edge37]

Worked! Thank you Cubist