Thread: countif on unformatted dates
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default countif on unformatted dates
Thank you very much

Peo Sjoblom wrote:
One possible way using your example
=SUMPRODUCT(--(INT(--SUBSTITUTE($A$1:$A$9,"'",""))=A11))

Reply With QuoteReply With Quote