Date Range Calculation
I'm a big fan of array formulas... hopefully you are familiar with
them. Below is the formula I used:
=SUM(IF(A2:A778=D3,IF(A2:A778<=D4,1,0),0))
A2:A778 -- was my range of dates
D3 -- cell with value of 1/1/2005
D4 -- cell with value of 12/31/2005
if you use this formula, after typing it, instead of just hitting enter
hit, ctrl-shift-enter... this makes it an array formula and it will put
{} around the formula.
KC wrote:
I need to calulate how many cells in one column have a date that are between
a range of dates for example 1/1/2005 through 12/31/2005.
Thanks.
|