DATEDIF Function

[Guest]

I am trying to calculate the total number of days between two dates. The problem is that my copy of Excel 2000 does not list 'DATEDIF' in the function list. When I enter this function, the cell returns an error. eg. DATEDIF(B2,G2,D)
Is there a way to get this function or is there something else wrong?

 

[IML]

On 2002-03-04 11:09, Anonymous wrote:
I am trying to calculate the total number of days between two dates. The problem is that my copy of Excel 2000 does not list 'DATEDIF' in the function list. When I enter this function, the cell returns an error. eg. DATEDIF(B2,G2,D)
Is there a way to get this function or is there something else wrong?

The format should be
=DATEDIF(B2,G2,"D")

for this rouge, sort of unrecognized / not documented function. You could, however, simply use
=G2-B2
and format to general.

good luck
This message was edited by IML on 2002-03-04 11:23