Count days between two separate dates

[Kuzad]

Hi i need a function that will count the amount of days that have elapsed between one date in the form of dd/mm/yyyy, and another date in the same format, and to show the amount of days that have occurred between these two dates.

Column a=date 1
column b=date 2
column c=amount of days between the two

thank you for your help in advance, it is really appreciated!

 

[kpark91]

Put this formula in C2 and format it as number:

=B2 - A2

 

[Kuzad]

It gives me a #value result if i do that

 

[Alphacsulb]

Column A format with Date. Column B Format with Date. Column C format with number.

Excel Workbook
	A	B	C
1	7/31/2011	7/21/2011	10
2	12/31/2011	7/5/2011	179
3	10/31/2011	8/1/2011	91
Sheet1

 

[Kuzad]

Gives me the #value result, i formatted them according to your specifications.

 

[jmthompson]

Are you sure your dates are dates and not text?

 

[Alphacsulb]

Open a new worksheet and see if it does the same thing. Can you post example dates?

 

[Kuzad]

Date 1: 16/04/2010
date 2: 20/05/2010
still gives me the #value result
i have formatted again and again, i have formatted the two columns according to date format, and doen it by cell, then by collumn, and still i get the same result. I opened a new worksheet, still the #value result.

 

[jmthompson]

test if the data is a number using ISNUMBER, as in =ISNUMBER(A1)

 

[Kuzad]

Apparently, it is not a number, it gives me the 'false' result.