Both Phillips and Alex are u so thanks that u have solve my problem and u
have quiet good discussion over that but
dear Bob phillips i can't follow u , i mean how 2 do the formula where
should i put the formula etc would u like to help me further. i will
appreciate it . and one thing more that i don't understand
=IF(IF(B11=4,DATE(B11,1,1),B11)--"1979-12-01","UNDERAGE","ADULT")
thanks minus after --
make me understand completely if u can cause i am newer to Excel
thanks

"Bob Phillips" wrote:

Alex,

I would never recommend using the serial date, it is error prone, and it
just makes it far too difficult to understand. For instance, I make 1st Dec
1979 is 29190 :-). There are better ways, such as DATE(1979,12,01), or, my
preference, --"1979-12-01".

The other thing I would do is make some assumption about years, such as
first day of year, so I would end up with

=IF(IF(B11=4,DATE(B11,1,1),B11)--"1979-12-01","UNDERAGE","ADULT")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alex" wrote in message
...
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","ADU
LT"))

[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