Unexpected value with date calculation
hi
try it this way,
=DATEDIF(B2,I5,"Y")
regards
FSt1
"Bob@HP" wrote:
b2 is set to =DATE(2007,6,9)
i5 is set to =DATE(2007,6,10)
h10's formula is =DATEDIF(I5,B2,"Y")
I'm expecting an answer of 0, but I get 107. The format of H10 is set to
general.
Any suggestions?
Thanks,
Bob
|