Graduate number in a cell
Closed
Femi
-
Apr 6, 2017 at 07:27 AM
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 - Apr 6, 2017 at 08:32 AM
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 - Apr 6, 2017 at 08:32 AM
Related:
- Graduate number in a cell
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Count if cell contains number - Excel Forum
- If cell contains specific text then return value in another cell vba ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Highlight cell if another cell contains text ✓ - Excel Forum
1 reply
Mazzaropi
Posts
1980
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 22, 2022
146
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