How to use a single part of a cell's date
Solved/Closed
TheMarcus
Posts
3
Registration date
Friday September 11, 2015
Status
Member
Last seen
September 15, 2015
-
Sep 11, 2015 at 06:22 AM
TheMarcus Posts 3 Registration date Friday September 11, 2015 Status Member Last seen September 15, 2015 - Sep 11, 2015 at 09:25 AM
TheMarcus Posts 3 Registration date Friday September 11, 2015 Status Member Last seen September 15, 2015 - Sep 11, 2015 at 09:25 AM
Related:
- How to use a single part of a cell's date
- Which key is used to make multiple line in a single cell - Guide
- Single beep on startup - Guide
- Mac single user mode reset password - Guide
- We can keep multiple version of a word document in a single file by using - Guide
- Excel escape single quote ✓ - Excel Forum
1 reply
Mazzaropi
Posts
1980
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 22, 2022
146
Sep 11, 2015 at 08:57 AM
Sep 11, 2015 at 08:57 AM
TheMarcus, Good morning.
To refer to an year inside a date in cell use:
=Year(D4)
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
To refer to an year inside a date in cell use:
=Year(D4)
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Sep 11, 2015 at 09:25 AM