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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Apr 6, 2017 at 08:32 AM
Related:
- Graduate number in a cell
- Conditional formatting if cell contains text - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Which key is used to make multiple line in a single cell - Guide
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Excel: If Date =, then enter a value ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Apr 6, 2017 at 08:32 AM
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
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
