Send me a workbook to look at.

--

HTH

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


"reneabesmer" wrote in message
...
Hiii Sir
it's still don't work my dear sir Bob Phillips
so what i can do , i am so confuse about it and i am been working manually
for Adult and underage people that really sucks
hope u will help me soon.
thanks


"Bob Phillips" wrote:

Is it because the dates are not real dates, but text?

Here is a nother variation to try


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

--

HTH

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


"reneabesmer" wrote in message
...
Bob Phillips i have again the problem ur formula don't work in Excel
when
i
import Access Table to Ms Excel and then when i apply ur formula on Ms
Access
Table in Ms Excel i don't know whyyy
could u help me plzzzzzzzzzzz
thankx


"Bob Phillips" wrote:

Okay I will try

I am using an IF to get a value that is used within an outer IF with
this
code IF(A2=4,DATE(A2,1,1),A2). What it says is that if A2 is only 4
digits,
i,e just a year assume a date that is 1st Jan of that year, else use
the
whole date. The value returned is then just compared against our
target
date
for under-ageness.

--

HTH

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


"reneabesmer" wrote in
message
...
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