Thanks Nick and Neo
Couldn't have thought of such prompt reply!

"Nick Hodge" wrote in message
...
Atif

1) Use the Datedif function with the day switch "d"

=DATEDIF(A5,A4,"d")

2) I suspect the regional settings in windows are set to US. Change these,
close and re-open Excel.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Atif" wrote in message
...
1. I have 2 columns : 1. start date 2. end date, how can I formulate in
the 3rd column to show the difference in days?

2. I have dates in custom format i.e dd mmm yy but still on the formula
bar it shows as d/m/yyyy. When I type in the date 2/1/05 it shows as 01
Feb 05 whereas it should show 02 Jan 05. What could be wrong here?



TIA