Ignoring weekends when subtracting dates

[robert_woodie]

i currently have 2 columns with 2 dates in them and i am subtracting one
from the other to find out the number of days between the 2, but i
would like to ignore weekends so it only takes into account mon-fri

is this possible ???

cheers

 

[Earl Kiosterud]

Robert,

Check out the NETWORKDAYS function. Got nothing to do with networks.
You'll need the analysis toolpak add-in (Tools - Addins).

 

[robert_woodie]

Thanx earl, your advice was spot on, just what i needed.

Thanx again
Robert.