Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count cells with a date falling within a 30 day period.
I want to count the number of cells that have a date entered, in a period of
30 days, in a column with over a thousand cells. Some of the cells are blank while others have random dates entered spanning a period of many years. (I.e. How many cells, in the above mentioned column, have a date that falls in the period between 21-Apr-2009 until 20-May-2009 ?) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count number of dates falling in the next seven days | Excel Worksheet Functions | |||
Number of dates falling in a date range | Excel Worksheet Functions | |||
How do I count the number of events in a 90 day period? | Excel Worksheet Functions | |||
Sum column based on value in each row, if two cells equal, or if date is within time period | Excel Worksheet Functions | |||
Count dates falling in a certain range | Excel Worksheet Functions |