count month when date is in day/month/year format
Pretty tough to tell you what is going wrong until you post the formulas you
used.
Regards,
Fred.
"ccKennedy" wrote in message
...
tried countif and tried sumproduct - it's not reading the date, which is
in
date format in excel, properly...
"Fred Smith" wrote:
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.
"ccKennedy" wrote in message
...
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.
|