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

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
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
0
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
0