MS Excel - Subtracting dates and removing weekends

[TheBeeKeeper]

Hello,
In MS Excel, I need to subtract two dates and find the difference between the two dates. When finding the difference between the two dates, I need to remove weekends. Is there a way to this?
Steve

 

[SkipVought]

Hi,

Take a look at the NETWORKDAYS function. It is part of the Analysis Toolpack Add-in.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[TheBeeKeeper]

Thanks for the reply..I am a rookie with Excel. Where can I find this tool?
Steve

 

[xlbo]

Tools>Add-Ins

tick Analysis Toolpak

If it ain't there, you will need the Office CD to install it

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question