date calculation help

[S]

A1 I have 01/01/08 (1st Jan)
A2 I have 14/01/08 (14th jan)

How do I get A3 to show 14 days, ie I want to subtract one date from another
but show the answer in days.

thanks

 

[G Lykos]

What do you get for "=A2-A1" in A3?

 

[S]

My apologies I never changed the cell format in A3, now works.