Dates and working days

[Ben Greenwood]

Can anyone help?

I have two columns with dates in them, and want to check
the first column (the "assigned" date) against the second
("completed" date) and have Excel respond true or false as
to whether the "completed" date is within 5 WORKING DAYS
of the "assigned".

Basically, I can't seem to make excel skip Saturdays and
Sundays in its calculations... certainly not in the IF
statement I'm currently using.

Any ideas?

Ben

 

[Frank Kabel]

Hi
use the function NETWORKDAYS
Note: you'll have to install the Analysis Toolpak Addin

 

[Guest]

Thanks, Frank, that worked a treat - you're a star!