G
Guest
i can use this formula in my excel {=DATEDIF(J5,H5,"d")} the results is VALUE
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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.
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.
J
JE McGimpsey
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.
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.
J
JE McGimpsey
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
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
D
Dave Peterson
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.
=h5-j5
and format as General (or not date)
J5 and H5 must be real dates.