| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if then based on date range
i have a column of dates. i'm trying to count how many in that column fall
within a particular date range. for example, column A has 15 rows of dates. i need the sum of which dates fall between 5/19 and 5/22 for example. thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then based on date range
Something similar to this
=COUNTIF(A1:A15,"5/18/2008")-COUNTIF(A1:A15,"5/22/2008") -- Best Regards, Luke M "Ann" wrote: i have a column of dates. i'm trying to count how many in that column fall within a particular date range. for example, column A has 15 rows of dates. i need the sum of which dates fall between 5/19 and 5/22 for example. thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then based on date range
ok, let me modify this.
a1: start date b1 5/19/08 a2: end date b2: 5/22/08 c3: 5/20/08 .. .. .. c55: 5/20/08 ok, based on the date ranges input for b1 and b2, whats the formula to look in column C and count the days which fall between these dates? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM Range based on date | Excel Worksheet Functions | |||
| Find category value based on date range? | Excel Worksheet Functions | |||
| Sumproduct based on Date range | Excel Worksheet Functions | |||
| Sum based on date range | Excel Discussion (Misc queries) | |||
| Calculation based with Range of Date | New Users to Excel | |||
Hybrid Mode
