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!

The DATEDIF function is available in all versions of Excel, but
is documented only in Excel 2000. For more information about
DATEDIF, see www.cpearson.com/excel/datedif.htm

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


"Joe McLain" <Joe wrote in
message
...
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!

http://www.cpearson.com/excel/datedif.htm


"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!

See Chip Pearson's site:

http://www.cpearson.com/excel/datedif.htm

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"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!

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!

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!

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!

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!