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
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Based on the cell values in cells b77 - Excel Forum
- Fill adjacent cell with number from text answer ✓ - Excel Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
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