Excel Networking days

[Cpreston]

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

 

[mikrom]

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

 

[Andrzejek]

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

 

[Andrzejek]

Was any of this helpful?

---- Andy

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

 

[SkipVought]

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!