Hi Nick,

Just subtract the oldest date from the newer one and format the result as General or Number, not Date.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Nick" wrote in message ...
| I've tried fornatting, to no avail.......I'm on Excel '97.
|
| Cheers
|
| Nick
|
|