Row Formats & IF Function

[Reenee]

Can I calculate if a person was 21 at the date of 1/1/08 or 7/1/08?

Also, can you tell me how to convert SSN numbers that were imported from a
database to a number format and no matter what I do by trying to format the cells it does not change. I have to go in each cell and take out the dashes but I have over 4K rows.

I have tried right clicking and format cells, special paste and nothing.

[martindwilson]

find /replace - with nothing for your example sorts out the numbers part
Then
=IF(DATE(YEAR(D2)+21,MONTH(D2),DAY(D2))<DATE(2008,1,1),"21 OR OVER 21 ON 1/1/08","UNDER21 as of 1/1/2008")

=IF(DATE(YEAR(D2)+21,MONTH(D2),DAY(D2))<DATE(2008,7,1),"21 OR OVER 21 ON 7/1/08","UNDER21 as of 7/1/2008")