Date counting
 

hi,
date resolved - date received = days
example
if date resolved = column G and date received = column F
formula in column H would be =G2-F2 then copy down.
formate column H to number

-----Original Message-----
I'm having a bad today. I have two columns for "date
complaint received" and
"date complaint resolved". I need to pull stats for all
complaints resolved
within 24 hours i.e. received and resolved today.

Anybody any ideas for a formula as I'm not too hot at
this sort of thing.

Cheers,
Darren
.