Formula
 

Is there a formula which calculates the WORKING DAYS between 2 dates, i.e. 1
date in A1 another in A2! Can i in A3 calculate the WORKING DAYS (not
weekends) between the 2 dates? I simply need the answer to be yes/no within
7 working days!!

Thanks in advance, Richard

Richard,

if you select the analysis toolpack addin, there is a function added to
excel =networkdays() that will do what you ask.


--
Kieran

Born ignorant and still perfecting the art
------------------------------------------------------------------------
Kieran's Profile: http://www.excelforum.com/member.php...fo&userid=1247
View this thread: http://www.excelforum.com/showthread...hreadid=277580