View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
henry
 
Posts: n/a
Default Date Counting problem

Maybe days360 might help, format the result C cell as number

D cell, what are you looking for?


"Sandy" skrev i en meddelelse
...
Hi wondering if I can get any can help solve my problem, I have 2 column
that
contains dates as shown below :

A B C D
(Reference cell)
1 01/01/2001 25/01/2001 24 =TODAY()
2 01/02/2001 0 ??

I have tried (without much success) using networkdays, count's etc etc.

Thanks in advance for any help/suggestions (except the rude ones ??)