Date Calculation

[Steve]

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

 

[Niek Otten]

Hi Steve,

Look in HELP for the NETWORKDAYS() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| 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
|

 

[Steve]

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

TIA
Steve

 

[Steve]

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

 

[Niek Otten]

<I also forgot to add I installed the Analysis Toolpak>

What do you mean by "installed"?

Did you

Tools>Add-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
| >
| >
| >
| > | >> Hi Steve,
| >>
| >> Look in HELP for the NETWORKDAYS() function
| >>
| >> --
| >> Kind regards,
| >>
| >> Niek Otten
| >> Microsoft MVP - Excel
| >>
| >>
| >> | >> | 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
| >> |
| >>
| >>
| >
| >
|
|