Graduate number in a cell [Closed]

Report
-
Posts
1887
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 27, 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
1887
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 27, 2021
141
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 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!