Previous Topic Next Topic

Graduate number in a cell

Closed
Femi - Apr 6, 2017 at 07:27 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Counting cells containing only numbers
jutulu -
jutulu -

4 responses