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