Calculating time between 2 dates DATEDIF Function

CDICKENS · Apr 28th, 2002, 02:40 PM

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

Tom Schreiner · Apr 28th, 2002, 02:44 PM

Put the D in quotes

"d"

CDICKENS · Apr 28th, 2002, 02:52 PM

Thanks I believe that worked!!

Aladin Akyurek · Apr 28th, 2002, 03:45 PM

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 28th, 2002, 02:40 PM	#1
CDICKENS Board Regular Join Date: Mar 2002 Posts: 444	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

Apr 28th, 2002, 02:44 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Put the D in quotes "d"

Apr 28th, 2002, 02:52 PM	#3
CDICKENS Board Regular Join Date: Mar 2002 Posts: 444	Thanks I believe that worked!!