Calculating time between 2 dates DATEDIF Function

[CDICKENS]

I want to calculate the number of days between 2 dates. The start_date is in A1 and the end_date is in A2.

When I format the function like this:
DATEDIF(A1,A2,D) I get the #NAME? error.

So I then tried it like this,
DATEDIF("A1","A2",D) I get the #value! error.

Since I already have the dates in the worksheet I do not want to enter them into the formula each time.

Help

 

[Legacy 98055]

Put the D in quotes

"d"

 

[CDICKENS]

Thanks I believe that worked!!

 

[Aladin Akyurek]

On 2002-04-28 13:52, CDICKENS wrote:
Thanks I believe that worked!!

=A2-A1

will also work. Need to format the cell of the formula as General.