Thread
:
counting the number of dates in a date range
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
smcmoran
external usenet poster
Posts: 10
counting the number of dates in a date range
Thank you, That worked perfectly and very simply. I was trying to complicate
the formula too much.
"Don Guillett" wrote:
try
=sumproduct((year(a2:a5000)=1927)*(year(a2:a5000) <=1937))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"smcmoran" wrote in message
...
I have a list of over 5000 birth dates i.e: 2/7/1975. I need to count the
number of times a cell has a date in a date range of years. For example I
need to know how many were born in the years 1927 thruogh 1937.
Scott
Reply With Quote
smcmoran
View Public Profile
Find all posts by smcmoran