Are you sure they are dates, compare them like =O1364-O1351
do you get a number as result or do you get the value error, if you get a
number they are real excel dates, if you get the error they are text and
cannot be used in calculations. If you don't have any leading or trailing
spaces you can convert them by copying an empty cell, select the dates and
do edit paste special and select add. However since you say you enter them
like 12/1/05 and use formatting to display as Dec-05 (I assume you had a
typo since 12/1/05 should not be Dec-06) then they are dates

Try

=COUNTIF('All Employees'!O1351:O1364,""&E1)-COUNTIF('All
Employees'!O1351:O1364,"="&F1)

and put the dates 12/31/05 in E1 and 02/01/06 in F1, make sure they are
dates (widen the column and see that they are right aligned without any
formatting applied) if you get zero it's text, if you get an error
then there's an error in the range itself or the formula has been copied and
pasted incorrectly


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"audreyglennette" wrote in
message ...
What do you mean real dates? I am entering them as 12/1/05 and having the
cell display as Dec-06 for conciseness. Is this wrong?