how do I get access to the datedif function?

J

Joe McLain

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

Sloth

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.
 
J

Joe McLain

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
----------------------------------
 
C

Chip Pearson

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


message
 
J

Joe McLain

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top