Bob

Thanks for your note. On your points...

(1) I wasn't aware that there were errors in the serial date function.
Thanks for drawing that to my attention.

(2)Your methodology concerning making assumptions about the year is good. It
offers greater precision and you offer a more robust solution.

Hopefully the original sender of the mesage is now equipped to carry out
their task at hand.

Regards


Alex

"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