Thread: Formula
View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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