View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nathan Jag Nathan Jag is offline
external usenet poster
 
Posts: 1
Default 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