Age filter problems,

Hi Guys, Nice to be here, I already learned a lot on this forum.

I have a question though..

I making an automated invoice system for my company, I want an automatic date answer and having lots of troubles doing it.

When the date of birth is filled in, i want an automated answer in de next cell, that says, child, youth or adult. Is this possible? thanks!

Attachment 367864

You must post an actual workbook:
To attach a Workbook
(please do not post pictures or links to worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

Try this

=IF(ROUNDDOWN((TODAY()-A2)/365.25,0)>18,"Adult",IF(ROUNDDOWN((TODAY()-A2)/365.25,0)>13,"Youth","Child"))

B2=DATEDIF(A2,TODAY(),"y")
C2=IF(B2>18,"Adult",IF(B2>13,"Youth","Child"))
both coped down

Note that your regional settings may need you to change , to ;

Also, please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version.

well if you open the workbook excel will auto change it to whatever settings you are using
click e2 have a look in the formula bar to see what changes then you'll know exactly what it should look like

next time you get a formula in english go here
http://en.excel-translator.de/

try inputting this formla
=LOOKUP(YEAR(TODAY()-$A2)-1900,{0,"Child";12,"Youth";18,"Adult"})

and choose dutch as your target language,choose ; as your separator
you dont have to worry much about version of excel unless its earlier or = 2003 then choose that
click translate
it will show you
=ZOEKEN(JAAR(VANDAAG()-$A2)-1900;{0;"Child";12;"Youth";18;"Adult"})