# Excel Networking days

Status
Not open for further replies.

#### Cpreston

##### MIS
Hi

I have a long list of dates in 2 columns and want to calculate the days between them but exclude weekends and bank holidays.

I have used =NETWORKDAYS(F2,G2,P210) The P210 have the bank holiday dates in but when I copy the formula down it changes for example =NETWORKDAYS(F3,G3,P311) so that takes out the range where the bank holiday dates are kept. Any ideas please.

Thanks

try:
=NETWORKDAYS(F2,G2,\$P\$2:\$P\$10)

You could also use Excel's named range:

then you formula would be:
[tt]=NETWORKDAYS(F2,G2,[blue]MyHolidays[/blue])[/tt]

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

I think it's most helpfully intuitive when List Headers and Table Headers (really one-in-the-same functionally) that those name correspond directly to Range Names, except for the fact that Range Names cannot contain SPACES but rather UNDERSCORES.

With that said, there's a feature in Formulas that enables you to name a Range using the Name at one of these 4 positions relative to the Selected Range: Top row, Bottom row, Left column or Right column.

Formulas > Create from Selection > Create names from values in the: [Top row, Bottom row, Left column or Right column]

In Andys example, the Range Name would simply be Holidays.

More or less a one step process with respect to typing a name.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

Status
Not open for further replies.

Replies
1
Views
106
Replies
7
Views
118
Replies
4
Views
93
Replies
2
Views
61
Replies
1
Views
76