I would look carefully and test thoroughly, if I were you, as the formulae
do not give identical results.
--
David Biddulph
"Max" wrote in message
...
Dave,
Curiously the original version worked (as the OP mentioned in the post)
when I plugged it in here, so I didn't pay that part of it further
attention since it wasn't the focus.
But I agree that your version -- which works, too -- is the better,
unambiguous way to go.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dave Peterson" wrote in message
...
Untested...
Should this:
=SUMIF(Hours!A10:A75,"12/31/07", ...
be more like:
=SUMIF(Hours!A10:A75,""&date(2007,12,31), ....