How do I count the number of records within a date range? New issu
My employer provides a database that I converted to excel with the following
values for dates... example... 01/01/2006. I need some help to build a formula to count the namber of cells that fall within a range of dates... for example 01/01/1955 to 12/31/1977. How do I do this? I've tried lots of ideas... nothing seems to work for me. |
How do I count the number of records within a date range? New issu
Hi Larry
There are many ways to achieve this. It is probably easiest to put the date ranges in cells e.g. enter in D1 01/01/1955 and in E1 12/31/1977 Then with your range of dates being in column A =COUNTIF(A:A,"="&D1)-COUNTIF(A:A,""&E1) This counts all the cells which have dates greater tna or equal to the first date, and subtracts the number that are greater than the last date Alternatively =SUMPRODUCT(($A$1:$A$1000=D1)*($A$1:$A$1000<=E1)) Note that you cannot use whole columns ranges with Sumproduct, just set the range long enough to cover your set of data. -- Regards Roger Govier "Larry G" wrote in message ... My employer provides a database that I converted to excel with the following values for dates... example... 01/01/2006. I need some help to build a formula to count the namber of cells that fall within a range of dates... for example 01/01/1955 to 12/31/1977. How do I do this? I've tried lots of ideas... nothing seems to work for me. |
All times are GMT +1. The time now is 09:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com