Date Counting problem
Hi there, D is the reference cell, and the result should only be in C this
result should be the number of days between the date in A1 and B1 (Full
dates), and in this case A2 (Full Date) and B2 where there is a 0 value as no
date is available at this time.
Thanks
"Ardus Petus" wrote:
Which results do you want to get in C2 & D2 ?
Cheers,
--
AP
"Sandy" a écrit dans le message de
...
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 ??)
|