View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SueK SueK is offline
external usenet poster
 
Posts: 29
Default COUNTIF date formula

Hello,
I have a column of dates in dd/mm/yyyy format, and I need to add up the
total number of instances in a given month. I have been trying to use a
COUNTIF (P:P, (DATE mm = "01")) formula, and a million and one other
configurations of this, and cannot get it to work, does anyone have any
suggestions?

Thanks