Try something like this:

For a list of dates/times in A1:A100
And a reference date in B1

The count of the B1 date in A1:A100 is:
C1: =SUMPRODUCT(--(TRUNC(A1:A100)=B1))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"sarjak" wrote:


I am trying to summarize a workbook. I have to count specific dates in
my summary (using fields from the previous sheets), however, the date
fields are Date/Time fields and cannot be separated. Is there someway I
can create a CountIf formula to ignore the time portion?
Thanks


--
sarjak
------------------------------------------------------------------------
sarjak's Profile: http://www.excelforum.com/member.php...o&userid=29402
View this thread: http://www.excelforum.com/showthread...hreadid=518376