View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sarjak
 
Posts: n/a
Default 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