Don't laugh, I know it's basic but i don't really use Excel and i need to make something for my boss!
I have a table that contains names and dates of birth, i need a formula to convert the Date of Birth DD/MM/YYY into age.
I need to then show which of the people are 16-18 and which are 19+, so i thought i would have two columns; 16-18 and 19+. What formula would i use so it would display a tick or a cross or something in the relevant column?
Hope that makes sense!!
eternal gratitude and rep for people who can help me!