Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula to count number of dates in an array
I have a column of dates and it will keep on increasing. I need a formula
that will count how many items I have between a start and an end date. I can do the =if portion but I'm tired of looking for how to get it to add up how many meet my condition. |
#2
|
|||
|
|||
With dates in column A, start date in C1, and end date in
D1, try: =COUNTIF(A:A,"="&C1)-COUNTIF(A:A,""&D1) HTH Jason Atlanta, GA -----Original Message----- I have a column of dates and it will keep on increasing. I need a formula that will count how many items I have between a start and an end date. I can do the =if portion but I'm tired of looking for how to get it to add up how many meet my condition. . |
#3
|
|||
|
|||
On Thu, 7 Apr 2005 10:45:05 -0700, "Lilasviolet"
wrote: I have a column of dates and it will keep on increasing. I need a formula that will count how many items I have between a start and an end date. I can do the =if portion but I'm tired of looking for how to get it to add up how many meet my condition. What do you mean, exactly? To count the number of rows that contain a date between the start and end dates: =COUNTIF(dts,"="&StartDate) - COUNTIF(dts,""&EndDate) where dts is your column containing the dates. The same logic can be applied to SUMIF if that is more appropriate for your setup. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
Count number of shaded cells | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
Count the number of words in a cell! | Excel Worksheet Functions |