Here are some problems that our users have asked and received explanations on
can excel calculate and return an age number in a cell, based on a birthdate in another cell?
Solved by M. C. in 11 mins
Need to take a DOB and calculate a persons age as of 6/01/2018
Solved by M. B. in 14 mins
Hi, My worksheet having column called Age, I need to count the Age group wise, IF(Age > 60 ,60,Age>45, 45, Age> 30, 30…))
Result as below
Age Group--> count
60--> 5
45-->4
30 -->10
Solved by G. Q. in 26 mins
I would like to calculate the age of a person with financial year 1/4/2018.
Eg: if the person birthdate is on 6/10/1980, born before financial year of 1/4/2018, his age should be 37 instead of 38. However, if the person is born before March 1980, his age shall be 38.
Solved by D. H. in 24 mins
I need to create a formula for an age calculator. In Column D I have the person's date of birth and in Column E I need the formula to calculate their current age.