CountIf on Date field

S

sarjak

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

Ron Coderre

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
 
S

sarjak

thank you for the reply. But I dont think this is what I am looking for.
I tried it and recieved a number, reformatted it to a date and was way
off.
 
D

Duke Carey

Ron's solution was perfect for the problem you stated.

Was the issue that the result came back as a date? If so, reformat as
General or Comma and you'll have your answer.

Was the issue that you didn't state your problem correctly? If so, try
again. & we'll try to help
 
Top