| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to count events w/in a timeframe?
To make answering easier my worksheets look somthing like this:
First tab contains: Group Entered Entry_Date Leave_DATE TEST NOV 11/1/2007 3/6/2008 CONTROL NOV 11/1/2007 4/5/2008 TEST DEC 12/1/2007 5/10/2008 CONTROL DEC 12/1/2007 12/1/2007 TEST JAN 1/1/2008 1/6/2008 CONTROL JAN 1/1/2008 3/6/2008 TEST FEB 2/1/2008 11/15/2008 CONTROL FEB 2/2/2008 3/6/2008 TEST MARCH 3/1/2008 4/28/2008 Second tab contains: Sent Mailing1 11/1/2007 Mailing2 11/28/2007 Mailing3 12/15/2007 Mailing4 1/4/2008 Mailing5 2/5/2008 Mailing6 2/16/2008 Mailing7 3/7/2008 Mailing8 3/18/2008 Mailing9 4/9/2008 Mailing10 5/1/2008 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can excel count concurrent events given start and end times ? | Excel Discussion (Misc queries) | |||
| SUMIF to calculate units sold in a specified timeframe | Excel Worksheet Functions | |||
| How do I summarize dates of events to a new worksheet to count ho. | Excel Worksheet Functions | |||
| counting dates within a timeframe | Setting up and Configuration of Excel | |||
| How do I count the number of events in a 90 day period? | Excel Worksheet Functions | |||
Threaded Mode
