Date Range Calculation
Awesome it worked. Thank you so much, this will save me so much time....
"Ron Coderre" wrote:
Try something like this:
B1: 1/1/2005 (start date)
B2: 12/31/2005 (end date)
B3: =SUMPRODUCT((A1:A1000=B1)*(A1:A1000<=B2))
OR...to count all dates witin one year:
B3: =SUMPRODUCT(--(YEAR(A1:A1000)=2005))
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"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.
|