Date counting
 

Hi Darren

received in A1, resolved in B1. Count "same day"
=SUMPRODUCT(1*(A1:A1000=B1:B1000))
count "not same day" (including one but not both cells empty)
=SUMPRODUCT(1*(A1:A1000<B1:B1000))

HTH. best wishes Harald

"Dazza" skrev i melding
...
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