| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to create a formula that counts dates
I have a complaints database that measures trends. One of the trends we will
be looking at is how many complaints were opened per week. The dates each complaint is opened uses this format 12-Nov-07. I need to count all the complaints opened in a particular week using the standard five day working week (mon-fri) for 52 weeks a year. Thanks in advance Craig |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to create a formula that counts dates
Craig,
With your list of dates in A1 - A200. Start date (12/11/2007) in B1 End date (16/11/2007) in B2 try this formula =COUNTIF(A1:A200,"="& B1)-COUNTIF(A1:A200,"="& B2) Mike "Craig" wrote: I have a complaints database that measures trends. One of the trends we will be looking at is how many complaints were opened per week. The dates each complaint is opened uses this format 12-Nov-07. I need to count all the complaints opened in a particular week using the standard five day working week (mon-fri) for 52 weeks a year. Thanks in advance Craig |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to create a formula that counts dates
That should of course have been
=COUNTIF(A1:A20,"="& B1)-COUNTIF(A1:A20,""& B2) Mike "Craig" wrote: I have a complaints database that measures trends. One of the trends we will be looking at is how many complaints were opened per week. The dates each complaint is opened uses this format 12-Nov-07. I need to count all the complaints opened in a particular week using the standard five day working week (mon-fri) for 52 weeks a year. Thanks in advance Craig |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create formula to calc difference in dates? | Excel Discussion (Misc queries) | |||
| HOW CREATE FORMULA TO ADD THE COLUMN CELLS THAT CONTAINING DATES | Excel Worksheet Functions | |||
| counts of dates | New Users to Excel | |||
| Formula to Create Consecutive #s for Non-Linear Dates | Excel Worksheet Functions | |||
| How can I create a formula to locate data between two dates? | Excel Worksheet Functions | |||
Linear Mode
