Chip,

Thank you very much! This is why teachers try to get us to follow all the
instructions in school, isn't it?!?

Sincerely,

Joe

"Chip Pearson" wrote:

Joe,

You need quotes around the 'd' character. E.g,.

=DATEDIF(N2,F2,"d")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Joe McLain" wrote in
message
...
I appreciate everyone's quick responses! I had come across
Chip's page on the
internet, which turned me on to the formula. However, I'm
still having an
issue. This is what I put in the cell:
=DATEDIF(N2,F2,d) - and I do have dates in N2 & F2.
The result is '#NAME?'.

Am I doing somthing wrong?

Sincerely,
Joe
----------------------------------
"Sloth" wrote:

You are going to have to type the formula in manually.

It sounds like you are trying to use the "paste function"
button. For some
reason the DATEDIF function is not included in any of the list
of functions.
You can still get help on it though, through the help.



"Joe McLain" wrote:

I want to compare two dates, without the time involved. I
see that Datedif
can do this, but I don't have it in my list of functions.
Can anyone help me
on how to get access to the function or another way to do
the compare,
ignoring time.

Thank you!