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

So that's the scenario, I've a date in a Cell (D4) in the format 02/02/2008.

I need to compare only the year of the date (2008) and if it's true return a frase.

Basicaly i need to know how to use a single part of a cell's date.

Tnx

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

Answer 1 / 1

Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
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

TheMarcus Posts 3 Registration date Friday September 11, 2015 Status Member Last seen September 15, 2015
Sep 11, 2015 at 09:25 AM

Yes that was exactly what i was searching for...thnx

Subscribe To Our Newsletter!