software

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.comquot;Joe McLainquot; lt;Joe gt; wrote in
message
...
gt;I want to compare two dates, without the time involved. I see
gt;that Datedif
gt; can do this, but I don't have it in my list of functions. Can
gt; anyone help me
gt; on how to get access to the function or another way to do the
gt; compare,
gt; ignoring time.
gt;
gt; Thank you!
www.cpearson.com/excel/datedif.htmquot;Joe McLainquot; wrote:

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

See Chip Pearson's site:

www.cpearson.com/excel/datedif.htm

Does that help?

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

XL2002, WinXP-Proquot;Joe McLainquot; wrote:

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

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

It sounds like you are trying to use the quot;paste functionquot; 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.
quot;Joe McLainquot; wrote:

gt; I want to compare two dates, without the time involved. I see that Datedif
gt; can do this, but I don't have it in my list of functions. Can anyone help me
gt; on how to get access to the function or another way to do the compare,
gt; ignoring time.
gt;
gt; 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 amp; F2.
The result is '#NAME?'.

Am I doing somthing wrong?

Sincerely,
Joe
----------------------------------
quot;Slothquot; wrote:

gt; You are going to have to type the formula in manually.
gt;
gt; It sounds like you are trying to use the quot;paste functionquot; button. For some
gt; reason the DATEDIF function is not included in any of the list of functions.
gt; You can still get help on it though, through the help.
gt;
gt;
gt;
gt; quot;Joe McLainquot; wrote:
gt;
gt; gt; I want to compare two dates, without the time involved. I see that Datedif
gt; gt; can do this, but I don't have it in my list of functions. Can anyone help me
gt; gt; on how to get access to the function or another way to do the compare,
gt; gt; ignoring time.
gt; gt;
gt; gt; Thank you!

Joe,

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

=DATEDIF(N2,F2,quot;dquot;)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Joe McLainquot; gt; wrote in
message
...
gt;I appreciate everyone's quick responses! I had come across
gt;Chip's page on the
gt; internet, which turned me on to the formula. However, I'm
gt; still having an
gt; issue. This is what I put in the cell:
gt; =DATEDIF(N2,F2,d) - and I do have dates in N2 amp; F2.
gt; The result is '#NAME?'.
gt;
gt; Am I doing somthing wrong?
gt;
gt; Sincerely,
gt; Joe
gt; ----------------------------------
gt; quot;Slothquot; wrote:
gt;
gt;gt; You are going to have to type the formula in manually.
gt;gt;
gt;gt; It sounds like you are trying to use the quot;paste functionquot;
gt;gt; button. For some
gt;gt; reason the DATEDIF function is not included in any of the list
gt;gt; of functions.
gt;gt; You can still get help on it though, through the help.
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Joe McLainquot; wrote:
gt;gt;
gt;gt; gt; I want to compare two dates, without the time involved. I
gt;gt; gt; see that Datedif
gt;gt; gt; can do this, but I don't have it in my list of functions.
gt;gt; gt; Can anyone help me
gt;gt; gt; on how to get access to the function or another way to do
gt;gt; gt; the compare,
gt;gt; gt; ignoring time.
gt;gt; gt;
gt;gt; gt; 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

quot;Chip Pearsonquot; wrote:

gt; Joe,
gt;
gt; You need quotes around the 'd' character. E.g,.
gt;
gt; =DATEDIF(N2,F2,quot;dquot;)
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;Joe McLainquot; gt; wrote in
gt; message
gt; ...
gt; gt;I appreciate everyone's quick responses! I had come across
gt; gt;Chip's page on the
gt; gt; internet, which turned me on to the formula. However, I'm
gt; gt; still having an
gt; gt; issue. This is what I put in the cell:
gt; gt; =DATEDIF(N2,F2,d) - and I do have dates in N2 amp; F2.
gt; gt; The result is '#NAME?'.
gt; gt;
gt; gt; Am I doing somthing wrong?
gt; gt;
gt; gt; Sincerely,
gt; gt; Joe
gt; gt; ----------------------------------
gt; gt; quot;Slothquot; wrote:
gt; gt;
gt; gt;gt; You are going to have to type the formula in manually.
gt; gt;gt;
gt; gt;gt; It sounds like you are trying to use the quot;paste functionquot;
gt; gt;gt; button. For some
gt; gt;gt; reason the DATEDIF function is not included in any of the list
gt; gt;gt; of functions.
gt; gt;gt; You can still get help on it though, through the help.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Joe McLainquot; wrote:
gt; gt;gt;
gt; gt;gt; gt; I want to compare two dates, without the time involved. I
gt; gt;gt; gt; see that Datedif
gt; gt;gt; gt; can do this, but I don't have it in my list of functions.
gt; gt;gt; gt; Can anyone help me
gt; gt;gt; gt; on how to get access to the function or another way to do
gt; gt;gt; gt; the compare,
gt; gt;gt; gt; ignoring time.
gt; gt;gt; gt;
gt; gt;gt; gt; Thank you!
gt;
gt;
gt;