Graduate number in a cell

[Closed]
Report
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
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

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month