Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Closed Date < 2 weeks of Open Date etc | Excel Worksheet Functions | |||
Counting Date Changes | Excel Discussion (Misc queries) | |||
Counting Date Changes | Excel Discussion (Misc queries) | |||
Counting Date Changes | Excel Discussion (Misc queries) | |||
excel formula counting date to date in 4 columns | Excel Worksheet Functions |