about this formula =DATEDIF(J5,H5,"d")
Hi,
That's wrong formula.
If you want to find if the cell contains Date, you can go for,
=If(IsDate(yourCell),"D"))
or
=IsNumber(yourCell)
the above formula will interpret both numbers and dates as produces boolean
(yes / no) result.
"insting" wrote:
i can use this formula in my excel {=DATEDIF(J5,H5,"d")} the results is VALUE
|