count month when date is in day/month/year format

  • Thread starter Thread starter ccKennedy
  • Start date Start date
C

ccKennedy

hello,
i need to count the number of times each of 5 reps made an entry in March.
the entry date is full date format (3-Mar-09) & the countif function isn't
workng.
example:
Rep Date Appt
Joe 3-mar-09 yes
Mary 5-mar-09 yes
etc

so, need to know how many times Joe made an entry in March, and need to know
how many appts were "yes" or made.
 
What formula did you use? Countif will do what when used properly.

When you post back, be sure to identify whether you have a true Excel date,
or whether it's text.

Regards,
Fred.
 
thank you, it's returning a "#VALUE!"
the date is in "date" format. will that still equate March to "3"?
 
tried countif and tried sumproduct - it's not reading the date, which is in
date format in excel, properly...
 
Pretty tough to tell you what is going wrong until you post the formulas you
used.

Regards,
Fred.
 
Back
Top