Hi Mark

I'm sorry. My stupid fault. Today() will always be greater than the dates
held in your cells, hence it should come second in the list
try
=DATEDIF(E2,TODAY(),"y")

Regards

Roger Govier


Mark C wrote:
Roger i tried that but it kept throwing up errors. It may be im just stupid
lol. I have the spreadsheet concerned if thats any help to you explaining it
to me

Mark

"Roger Govier" wrote:


Hi Mark

In another column (F?) on the sheet enter Age as a heading and in cell 2 enter
=DATEDIF(TODAY(),E2,"y")
assuming your date are in column E and starting in row 2, otherwise amend to
suit.
Copy this formula down for the 450 rows of your data.

Now, mark A1:F1, DataFilterAutofilter and use the dropdown on the Age
column to select 18

Regards

Roger Govier


Mark C wrote:

I have a spreadsheet that records members of an 13 to 18 year old disco club.
We record their Name, Address, Post Code, Phone Number and Date of Birth.
There are over 450 members.
What i am trying to do i get excel to alert me as to when a member reaches
18 years of age so i can remove them from the sheet.
Can someone assist me in creating some thing that can do this (If its
possible in excel)
Otherwise it takes an age trawling through the records. : (
Thanks

Mark