February 2, 2013
July 16, 2010
In Excel dates are numbers too. They're stored as date serial numbers, so it's not as simple as identifying which values are dates vs numbers simply by the value itself.
If you have an adjacent column with a criteria, you can use, like you do in the example file in column B, then you can use a SUMIF formula like so: