Hello

Ok. Quite simple I think.

The 'serial' date for 01-Dec-1979 in Excel is 29220. Excel uses serial
numbers to store dates. All you need to know is that 01-Dec-1979 = 29220.

As I undertand it you have a list of dates in column C and want to assess
whther they are 'UNDERAGE' or 'ADULT' using 01-Dec-1979 as the cut-off.

Column C Column D
1-Jan-1980 =formula
23-Jul-1985
03-Apr-2002
1980
03-Nov-1996
1958

In column D1 (where I have put = formula), type in the formula as shown
below and then drag down to calculate for all cells.

=IF(LEN(B46)4,IF(B4629220,"UNDERAGE","ADULT"),IF (B46=1980,"UNDERAGE","ADULT"))

[NB - the formula is all one line - it appears as two lines here due to
space constaints)

This will take care of dates whether they are of the format dd-mm-yyyy or
just simply yyyy.

I hope this helps. If there are any problems then please write back and I
shall endeavour to assist you further.

Regards


Alex



"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