=A1-A2
Format as General, not as date (which is what Excel does automatically)
--
Kind regards,
Niek Otten
"Clash" wrote in message
...
|
| Hi all,
|
| Can someone please help.
|
| I can't work out how to get a formula to work out the difference in
| days between two dates.
|
| e.g. 12/10/2006 and 14/10/2006 = 2 days
|
| please help.
|
|
| --
| Clash
| ------------------------------------------------------------------------
| Clash's Profile:
http://www.excelforum.com/member.php...o&userid=18951
| View this thread:
http://www.excelforum.com/showthread...hreadid=538351
|