| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I Count number of records beteen two dates- Excell 2007
In Excel 2007:
Using cells to hold the date periods. K2 = start date = 4/1/2008 (m/d/y) L2 = end date = 4/28/2008 (m/d/y) =COUNTIFS(I2:I3000,"="&K2,I2:I3000,"<="&L2) -- Biff Microsoft Excel MVP "DK" wrote in message ... need to count the number of records between two specific dates. Dates are in column i2:i3000. Need to know how many record falls into period 1 1/4/08 to 28/4/08 inclusive; period 2 29/4/08 to 26/5/08 inclusive etc? Any advice |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - count the number of records between two specific dates. | Excel Worksheet Functions | |||
| Count certain records between dates | Excel Discussion (Misc queries) | |||
| Number of records between dates | Excel Discussion (Misc queries) | |||
| Count the number of unique records | Excel Worksheet Functions | |||
| count the no.of records between two dates | Excel Worksheet Functions | |||
Threaded Mode
