Sorting out age ranges with birth dates in cells.

[mistyh6286]

I have a spreadsheet that I need to pull out the people who are in between the ages of 50-75. All I have listed are birth dates in the rows, how do I achieve this?

TIA

 

[Dave Patton]

Excel 2010
	A	B	C
1	Effective date	21-Jul-17
2	Name	DOB
3		21-Jul-67	TRUE
4		15-Feb-70	FALSE
5		5-May-55	TRUE
6
5a

Cell Formulas
Range	Formula
B3	=-365.25*50+B1
C3	=DATEDIF(B3,$B$1,"y")>=50
C4	=DATEDIF(B4,$B$1,"y")>=50
C5	=DATEDIF(B5,$B$1,"y")>=50

You could then filter the list.

 

[Dave Patton]

I didn't post the formula that tested both lower and upper date; see below.

=AND(DATEDIF(B3,$B$1,"y")>=50,DATEDIF(B3,$B$1,"y")<=75)