| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count month when date is in day/month/year format
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count month when date is in day/month/year format
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
| date format only showing month year | Excel Discussion (Misc queries) | |||
| Format date with just month and year | Excel Discussion (Misc queries) | |||
| I need date format to be set up as month/year. | New Users to Excel | |||
| Month Year Date Format | Excel Worksheet Functions | |||
![Fred Smith[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
