thanks Bob i do understand what is mean by -- but still i have the problem 2
understand rest of the formula. and one thing 2 remind u that we OSI Date.
let me explain my problem again with the formula
Column A Column B
1-jan-1980 =IF(IF(A2=4,DATE(A2,1,1),A2)--"1979-12-01","UNDERAGE","ADULT")
1979
15-apr-1958

it gives me the correct result so thanks alot for that
but dear friend would u like 2 explain =if(if(A2=4,date(A2,1,1),A2)
plz i need some detail of it.
i really Appreciate ur help





"reneabesmer" wrote:

so dear friends i am working in an NGOs here in Afghanistan
and here i have my data about populations and those whos age is less then
31-dec-1979 are called underage and the rest of called Adult
so how can find the correct result , my date in age Column in Excel sheet
is below

Column c
1-jan-1980
23-jul-1985
3-apr-2002
1980
3-nov-1996
1958

so i have such kind of data . so plz i really need ur help. that must be
appreciated.
thanks alot
Looking forward for Solution