Countif date range

[xbrianx]

I have a range of dates (partial example below) and want to find out the number of people with a DOB older than 50 years old. What is the formula?

<table border="0" cellpadding="0" cellspacing="0" width="95"><col style="width: 71pt;" width="95"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 71pt; font-size: 10pt; color: white; font-weight: 700; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color; background: none repeat scroll 0% 0% rgb(79, 129, 189);" width="95" height="17">BIRTHDATE</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color; background: none repeat scroll 0% 0% rgb(220, 230, 241);" align="right" height="17">6/1/1977</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color;" align="right" height="17">5/2/1986</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color; background: none repeat scroll 0% 0% rgb(220, 230, 241);" align="right" height="17">3/9/1950</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color;" align="right" height="17">10/25/1983</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color; background: none repeat scroll 0% 0% rgb(220, 230, 241);" align="right" height="17">5/30/1970</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color;" align="right" height="17">6/15/1981</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color; background: none repeat scroll 0% 0% rgb(220, 230, 241);" align="right" height="17">6/15/1961</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color;" align="right" height="17">1/20/1984</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color; background: none repeat scroll 0% 0% rgb(220, 230, 241);" align="right" height="17">8/27/1963</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color;" align="right" height="17">2/24/1950</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color; background: none repeat scroll 0% 0% rgb(220, 230, 241);" align="right" height="17">10/24/1980</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color;" align="right" height="17">12/14/1980</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color; background: none repeat scroll 0% 0% rgb(220, 230, 241);" align="right" height="17">3/1/1981</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color;" align="right" height="17">6/23/1987</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color; background: none repeat scroll 0% 0% rgb(220, 230, 241);" align="right" height="17">11/16/1963</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color;" align="right" height="17">12/19/1944</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color; background: none repeat scroll 0% 0% rgb(220, 230, 241);" align="right" height="17">5/18/1950</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color;" align="right" height="17">10/24/1948</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color; background: none repeat scroll 0% 0% rgb(220, 230, 241);" align="right" height="17">7/2/1949</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color;" align="right" height="17">1/15/1965</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color; background: none repeat scroll 0% 0% rgb(220, 230, 241);" align="right" height="17">1/15/1965</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color;" align="right" height="17">2/4/1963</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color; background: none repeat scroll 0% 0% rgb(220, 230, 241);" align="right" height="17">9/21/1958</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color;" align="right" height="17">3/16/1964</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color; background: none repeat scroll 0% 0% rgb(220, 230, 241);" align="right" height="17">3/2/1957</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color;" align="right" height="17">11/25/1969</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: Arial; border-width: 0.5pt medium; border-style: solid none; border-color: rgb(149, 179, 215) -moz-use-text-color; background: none repeat scroll 0% 0% rgb(220, 230, 241);" align="right" height="17">5/16/1955</td> </tr> </tbody></table>

 

[T. Valko]

I have a range of dates (partial example below) and want to find out the number of people with a DOB older than 50 years old. What is the formula?

<TABLE cellSpacing=0 cellPadding=0 width=95 border=0><COLGROUP><COL style="WIDTH: 71pt" width=95><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: rgb(79,129,189); BORDER-LEFT: medium none; WIDTH: 71pt; COLOR: white; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" width=95 height=17>BIRTHDATE</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: rgb(220,230,241); BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>6/1/1977</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>5/2/1986</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: rgb(220,230,241); BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>3/9/1950</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>10/25/1983</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: rgb(220,230,241); BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>5/30/1970</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>6/15/1981</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: rgb(220,230,241); BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>6/15/1961</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>1/20/1984</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: rgb(220,230,241); BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>8/27/1963</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>2/24/1950</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: rgb(220,230,241); BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>10/24/1980</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>12/14/1980</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: rgb(220,230,241); BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>3/1/1981</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>6/23/1987</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: rgb(220,230,241); BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>11/16/1963</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>12/19/1944</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: rgb(220,230,241); BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>5/18/1950</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>10/24/1948</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: rgb(220,230,241); BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>7/2/1949</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>1/15/1965</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: rgb(220,230,241); BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>1/15/1965</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>2/4/1963</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: rgb(220,230,241); BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>9/21/1958</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>3/16/1964</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: rgb(220,230,241); BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>3/2/1957</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>11/25/1969</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: medium none; BORDER-TOP: rgb(149,179,215) 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: rgb(220,230,241); BORDER-LEFT: medium none; COLOR: black; BORDER-BOTTOM: 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none" align=right height=17>5/16/1955</TD></TR></TBODY></TABLE>

Unfortunately, this is not as easy as it would seem to be.

Let's assume your data is the range A2:A28.

Enter this formula in B2 and copy down to B28:

=EDATE(A2,50*12)

Then to get the number of people that are 50 years of age or older...

=COUNTIF(B2:B28,"<="&TODAY())

Note that the EDATE function requires the Analysis ToolPak
add-in be installed if you're using a version of Excel prior to
Excel 2007. If you enter the formula and get a #NAME?
error look in Excel help for the EDATE function. It'll tell you
how to fix the problem.

 

[scottylad2]

maybe this

Excel Workbook
	D	E
2	BIRTHDATE	Todays Date
3	06/01/1977	12/07/2011
4	05/02/1986	10
5	03/09/1950
6	25/10/1983
7	30/05/1983
8	15/06/1981
9	15/06/1961
10	20/01/1965
11	27/08/1963
12	24/02/1924
13	24/10/1984
14	14/12/1980
15	03/01/1981
16	23/06/1987
17	16/11/1963
18	19/12/1944
19	18/05/1950
20	24/10/1948
21	07/02/1949
22	15/01/1965
23	15/01/1955
24	02/04/1963
25	21/01/1958
26	16/03/1968
27	03/02/1957
28	25/11/1969
29	16/05/1955
Sheet1

 

[xbrianx]

Unfortunately, this is not as easy as it would seem to be.

Let's assume your data is the range A2:A28.

Enter this formula in B2 and copy down to B28:

=EDATE(A2,50*12)

Then to get the number of people that are 50 years of age or older...

=COUNTIF(B2:B28,"<="&TODAY())

Note that the EDATE function requires the Analysis ToolPak
add-in be installed if you're using a version of Excel prior to
Excel 2007. If you enter the formula and get a #NAME?
error look in Excel help for the EDATE function. It'll tell you
how to fix the problem.

Not sure what the EDATE function is but that did the trick, thanks!

 

[T. Valko]

Not sure what the EDATE function is but that did the trick, thanks!

EDATE stands for end date. What we did was calculate the date of the persons 50th birthday. Then we counted how many of those dates were less than or equal to todays date.

Also check out scottylad2's formula. It works as well without needing a helper column.

I think you'd need to change the operator from > to >=.

=SUMPRODUCT(--(DATEDIF(D3:D29,E$3,"y")>=50))