Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
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) | |||
date counting | Excel Worksheet Functions | |||
excel formula counting date to date in 4 columns | Excel Worksheet Functions | |||
Date counting | Excel Programming |