about this formula =DATEDIF(J5,H5,"d")
 

i can use this formula in my excel {=DATEDIF(J5,H5,"d")} the results is VALUE

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

about this formula =DATEDIF(J5,H5,"d")
 

First, if by {...} you're indicating that you're array-entering the
formula, you don't need to.

What are the values in J5 and H5? DATEDIF requires that J5 and H5 are
dates (and J5<=H5). If they are Text, instead, you'll get the #VALUE!
error.


In article ,
insting wrote:

i can use this formula in my excel {=DATEDIF(J5,H5,"d")} the results is VALUE

about this formula =DATEDIF(J5,H5,"d")
 

Huh?

IsDate isn't an XL function, and the OP's function works fine if J5 and
H5 are dates, with J5<=H5.

If you're not familiar with DATEDIF, see

http://cpearson.com/excel/datedif.aspx


In article ,
Nathan Jag <Nathan wrote:

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

about this formula =DATEDIF(J5,H5,"d")
 

And if you're really interested in the difference in days, you can use:

=h5-j5
and format as General (or not date)

J5 and H5 must be real dates.

insting wrote:

i can use this formula in my excel {=DATEDIF(J5,H5,"d")} the results is VALUE

--

Dave Peterson