Graduate number in a cell
[Closed]
Report
Femi
-
Mazzaropi
Mazzaropi
- Posts
- 1943
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- September 22, 2021
Related:
- 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
- What values are possible for cells that contain numbers, dates and text? ✓ - Forum - Excel
- Google sheets if cell contains any text then ✓ - Forum - Excel
- Highlight at most 7 cells so that all unhighlighted cells are next to a highlighted cell - Forum - Excel
1 reply
Mazzaropi
- Posts
- 1943
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- September 22, 2021
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
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
