Thread: And(countif(
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mr.Cools Mr.Cools is offline
external usenet poster
  
Posts: 11
Default And(countif(
Ray payette's formula should be
=COUNTIF(A1:A313,"="&DATE(2006,8,1))-COUNTIF(A1:A31,""&DATE(2006,9,1))

Reply With QuoteReply With Quote