Here are some problems that our users have asked and received explanations on
I need a formula that analyzes a date of birth. Specifically, if the age of the person is age 1 or younger, then I would like for excel to give me the quarterly dates from the date of birth to age 1.
Solved by V. S. in 21 mins
sir, how to find age calculator age on date formula
Solved by A. A. in 22 mins
I need a formula to determine an age group based on age at June 16, 2018 (which I know) - and predetermined age groups.
Solved by A. D. in 22 mins
Im trying to create a variable age group with the following conditions
takes "1" when age <5
takes "2" when age>=5 and <10
takes "3" when age>=10 and <20
takes "4" when age>=20 and <30
takes "5" when age>=30
but i am not sure how to write a formula for this
Solved by F. A. in 26 mins
I have first 2 columns with starting age and ending age. then few criteria like (Column 3) should have people with age between 0-2 and so on till age 16.
I need a formula to automatically fill 1 in all the relevant columns.