Date Calculation
 

Hi

Anyone know how I can calculate the amount of days between two dates
not
taking into account weekends and possible Bank holidays?

TIA
Steve

Date Calculation
 

Hi Steve,

Look in HELP for the NETWORKDAYS() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Steve" wrote in message ups.com...
| Hi
|
| Anyone know how I can calculate the amount of days between two dates
| not
| taking into account weekends and possible Bank holidays?
|
| TIA
| Steve
|

Date Calculation
 

I've tried the =networkdays(A1,A2) function, formatted the cell as a number
but it keeps coming up with #NAME?

TIA
Steve



"Niek Otten" wrote in message
...
Hi Steve,

Look in HELP for the NETWORKDAYS() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Steve" wrote in message
ups.com...
| Hi
|
| Anyone know how I can calculate the amount of days between two dates
| not
| taking into account weekends and possible Bank holidays?
|
| TIA
| Steve
|

Date Calculation
 

I've tried the =networkdays(A1,A2) function, formatted the cell as a number
but it keeps coming up with #NAME?

I also forgot to add I installed the Analysis Toolpak

TIA
Steve



"Niek Otten" wrote in message
...
Hi Steve,

Look in HELP for the NETWORKDAYS() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Steve" wrote in message
ups.com...
| Hi
|
| Anyone know how I can calculate the amount of days between two dates
| not
| taking into account weekends and possible Bank holidays?
|
| TIA
| Steve
|

Date Calculation
 

<I also forgot to add I installed the Analysis Toolpak

What do you mean by "installed"?

Did you

ToolsAdd-ins, check Analysis Toolpak?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Steve" <swr1953(at)yahoo(dot)co(dot)uk wrote in message ...
|
| I've tried the =networkdays(A1,A2) function, formatted the cell as a number
| but it keeps coming up with #NAME?
|
| I also forgot to add I installed the Analysis Toolpak
|
| TIA
| Steve
|
|
|
| "Niek Otten" wrote in message
| ...
| Hi Steve,
|
| Look in HELP for the NETWORKDAYS() function
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|
| "Steve" wrote in message
| ups.com...
| | Hi
| |
| | Anyone know how I can calculate the amount of days between two dates
| | not
| | taking into account weekends and possible Bank holidays?
| |
| | TIA
| | Steve
| |
|
|
|
|
|
|