how do I get access to the datedif function?

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 McLain@discussions.microsoft.com> wrote in
message
news:B8A03B7B-EDFC-4A13-9ED8-450C5A1864F4@microsoft.com...
>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" <JoeMcLain@discussions.microsoft.com> wrote in
message
news:B4FE38F2-E855-40D7-9CB3-A057E11D11B7@microsoft.com...
>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" <JoeMcLain@discussions.microsoft.com> wrote in
> message
> news:B4FE38F2-E855-40D7-9CB3-A057E11D11B7@microsoft.com...
> >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!
>
>
>