Graduate number in a cell [Closed]

Question

Graduate number in a cell [Closed]

Report

Femi - Apr 6, 2017 at 07:27 AM
Mazzaropi

Posts: 1887
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: February 27, 2021

- Apr 6, 2017 at 08:32 AM

Hello,

I have this database on Excel that I want to create.
One of the columns will have the date of birth (DOB) and another column will have the year such that a person born on 23/04/2000 (Column B) will be 17 (Column C) years in 2017.
Now, I want the Column C to graduate each year without manually altering it. Using the previous example, in 2018, the person should be 18 years.
Please help. Thanks

Graduate number in a cell
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Forum - Excel
Excel if cell contains date then return value ✓ - Forum - Office Software
Cell phone country code usa - How-To - Mobile
How do i block a private number on my cell phone - How-To - Android
Excel copy row to another sheet based on cell value ✓ - Forum - Excel

1 reply

Ask a question

Mazzaropi · Accepted Answer · 2017-04-06T08:32:14-0400

Answer 1 / 1

Mazzaropi

Posts: 1887
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: February 27, 2021

141
Apr 6, 2017 at 08:32 AM

Femi, Good morning.

Suppose:
B1 --> DOB --> 23/04/2000

Try to use:
C1 --> =YEAR(TODAY())-YEAR(B1)

If you need a REAL AGE try this one:
D1 --> =DATEDIF(B1,TODAY(),"Y") & " Years " & DATEDIF(B1,TODAY(),"YM") &" Months
" & DATEDIF(B1,TODAY(),"MD") & " Days")

I that what you want?
I hopeit helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Graduate number in a cell [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!