Date Formulas and number of days between

[dwalters]

Hi

I have 2 columns in a spreadsheet each one contains a different date e.g Column 1 - Sat 31 Jan 15 and Column 2 - Tue 3 Feb 15. I would like to be able to type in 31/1/15 and it automatically changes to Sat 31 Jan 15, essentially it works out the DAY itself. Is this possible? Further to being able to display the date in each column I then want to calculate the days between the dates including the dates shown so Sat 31 Jan 15 and Tue 3 Feb 15 will show 4 days.

Thanks in advance for your help.

[samba_ravi]

[$-409]ddd dd mmm yyyy
Try the above in Custom under format cells