How to use a single part of a cell's date

Solved/Closed
TheMarcus Posts 2 Registration date Friday 11 September 2015 Status Member Last seen 15 September 2015 - 11 Sep 2015 à 06:22
TheMarcus Posts 2 Registration date Friday 11 September 2015 Status Member Last seen 15 September 2015 - 11 Sep 2015 à 09:25
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

1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
11 Sep 2015 à 08:57
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 2 Registration date Friday 11 September 2015 Status Member Last seen 15 September 2015
11 Sep 2015 à 09:25
Yes that was exactly what i was searching for...thnx