A few days ago
What is the Excel function for age in total years?
In Excel, lets say my birthday is 2/14/1985 and todays date is obviously 12/2/2007. How can i find out my age in total years?
Top 2 Answers
A few days ago
Favorite Answer
Assuming that your birthdate is in cell A1, I would use the following formula:
=( TODAY() – A1 ) / 365
If you want to display only whole-number years, then use this one:
=ROUNDDOWN ( ( TODAY() – A1 ) / 365, 0 )
0
A few days ago
Put 2/14/1985 in one cell, and 12/2/2007 in another. Take the difference between the two cells and divide by 365…..22.81 (so 22 years).
Or use the function YEARFRAC(first date, second date).
0
- Academic Writing
- Accounting
- Anthropology
- Article
- Blog
- Business
- Career
- Case Study
- Critical Thinking
- Culture
- Dissertation
- Education
- Education Questions
- Essay Tips
- Essay Writing
- Finance
- Free Essay Samples
- Free Essay Templates
- Free Essay Topics
- Health
- History
- Human Resources
- Law
- Literature
- Management
- Marketing
- Nursing
- other
- Politics
- Problem Solving
- Psychology
- Report
- Research Paper
- Review Writing
- Social Issues
- Speech Writing
- Term Paper
- Thesis Writing
- Writing Styles