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

Hi Steve,

Look in HELP for the NETWORKDAYS() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Steve" <[email protected]> wrote in message news:[email protected]...
| 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
|

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" <[email protected]> wrote in message
news:[email protected]...
> Hi Steve,
>
> Look in HELP for the NETWORKDAYS() function
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
>
> "Steve" <[email protected]> wrote in message
> news:[email protected]...
> | 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
> |
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> Hi Steve,
>
> Look in HELP for the NETWORKDAYS() function
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
>
> "Steve" <[email protected]> wrote in message
> news:[email protected]...
> | 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
> |
>
>

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" <[email protected]> wrote in message
> news:[email protected]...
>> Hi Steve,
>>
>> Look in HELP for the NETWORKDAYS() function
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>> Microsoft MVP - Excel
>>
>>
>> "Steve" <[email protected]> wrote in message
>> news:[email protected]...
>> | 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
>> |
>>
>>
>
>

<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 news:[email protected]...
|
| 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" <[email protected]> wrote in message
| > news:[email protected]...
| >> Hi Steve,
| >>
| >> Look in HELP for the NETWORKDAYS() function
| >>
| >> --
| >> Kind regards,
| >>
| >> Niek Otten
| >> Microsoft MVP - Excel
| >>
| >>
| >> "Steve" <[email protected]> wrote in message
| >> news:[email protected]...
| >> | 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
| >> |
| >>
| >>
| >
| >
|
|