Formula
 

Is there a formula for working out the WORKING DAYS between two cells? For
instance if i had one date in A1 another in A2, could I in A3 work out simply
if the dates exceeded 7 Working days or not, must be working days not
consecutive days!!??

Thanks in advance, Richard

Hi
use
=NETWORKDAYS(A1,A2)

Note: You must activate the Analysis toolpak Addin for using this
function

--
Regards
Frank Kabel
Frankfurt, Germany

"Richard" schrieb im Newsbeitrag
...
Is there a formula for working out the WORKING DAYS between two
cells? For
instance if i had one date in A1 another in A2, could I in A3 work
out simply
if the dates exceeded 7 Working days or not, must be working days not
consecutive days!!??

Thanks in advance, Richard