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!

 

[jmthompson]

You'll need to convert to numbers using text to columns and then the formulas listed previously will work

 

[Kuzad]

How do i do this?

 

[jmthompson]

Highlight the column with the dates, Data, Text to Columns, delimited, tab, column format as date, choose your format, finish.

 

[Alphacsulb]

Another issue is that the default in excel is mm/dd/yyyy, NOT dd/mm/yyyy.

 

[Kuzad]

Thank you for your help