# Formula Min&Max&Networkdays

#### jevi

##### Active Member
Hi everyone,

I have this formula which is counting the number of days that fall between two dates 15/06/20/20 and 30/09/2020, but now I need it also for another range and I don't know how to do it.

B43: 12/06/2020 (the first day of the holiday)
C43: 14/06/2020 (the last day of the holiday)
F40: 16/06/2020 (16/09/2020 - 30/09/2020 the intervallo that I need to count the days of holidays that fall between these to days)
G40: 30/09/2020

But I need to add to the formula another intervallo so 15/10/2020 - 10/12/2020. I can do it seperatly for each range but I was curious if it can be done in a solo formula for both ranges.

=MAX(0;NETWORKDAYS(MAX(B43;\$F\$40);MIN(C43;\$G\$40);\$C\$9:\$C\$20))

Thank you,

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

Replies
9
Views
186
Replies
6
Views
192
Replies
0
Views
84
Replies
7
Views
195
Replies
33
Views
680

Threads
1,126,925
Messages
5,621,631
Members
415,848
Latest member
LCC

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back