If you simply want to count entries in July-08 you could leave the data as is
and use

=SUMPRODUCT((MONTH(A1:A100)=7)*(YEAR(A1:A100)=2008 ))

"Max" wrote:

One tinker ..

In B1, copied down:
=TEXT(A1,"'mmm-dd")&" "&TEXT(A1,"h:mm:ss AM/PM")

Then in C1:
=SUMPRODUCT(--ISNUMBER(SEARCH("Jul-07",B1:B100)))
to count
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik
---
"mommy2kh" wrote:
Thanks for your reply. I have the Custom Format set up already but that only
changes the way the data is viewed, not the actual cell content. Is there a
way to change part of a cell's content? Thanks!