| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how would I count dates (not # of days) in cells that fall betwee.
Using excel, how would you count occurances of dates that fall between 2
dates? Thank you, sailingscotts |
|
#2
|
|||
|
|||
|
One way ...
Assuming the dates are real dates, and in A1:A100 down: try something like this in say, B1: =SUMPRODUCT((A1:A100=DATE(2005,7,1))*(A1:A100<=DA TE(2005,7,15))) which counts the # of cells within A1:A100 with dates between 1st July 2005 and 15th July 2005 (inclusive) Adapt to suit. Note that we can't use entire col references in SUMPRODUCT -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "sailingscotts" wrote in message ... Using excel, how would you count occurances of dates that fall between 2 dates? Thank you, sailingscotts |
|
#3
|
|||
|
|||
|
Thank you, Max!
"Max" wrote: One way ... Assuming the dates are real dates, and in A1:A100 down: try something like this in say, B1: =SUMPRODUCT((A1:A100=DATE(2005,7,1))*(A1:A100<=DA TE(2005,7,15))) which counts the # of cells within A1:A100 with dates between 1st July 2005 and 15th July 2005 (inclusive) Adapt to suit. Note that we can't use entire col references in SUMPRODUCT -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "sailingscotts" wrote in message ... Using excel, how would you count occurances of dates that fall between 2 dates? Thank you, sailingscotts |
|
#4
|
|||
|
|||
|
You're welcome !
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "sailingscotts" wrote in message ... Thank you, Max! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to find and flag dates older than 30 days | Excel Worksheet Functions | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| Count non-colored cells | Excel Discussion (Misc queries) | |||
| Subracting Dates to come up with the # of days between them | Excel Worksheet Functions | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Linear Mode
