you could use
=datedif(Date1,Date2,"d")

datedif() is a useful function in EXCEL, but you won't find it in help

"Nick" wrote:

I've tried fornatting, to no avail.......I'm on Excel '97.

Cheers

Nick