CountIf on Date field
 

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

CountIf on Date field
 

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

CountIf on Date field
 

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.


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

CountIf on Date field
 

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
"sarjak" wrote:


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.


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