Previous Topic Next Topic

Graduate number in a cell

Closed
Femi - Apr 6, 2017 at 07:27 AM
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 - 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

1 reply

Answer 1 / 1
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
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
1