Obtaining just the Year out of the date

[Learning Excel]

Is it possible to obtain just the year in B1 out of a whole date in A1 ?
I need to use the date in A1, in order to get a year, just THAT year in B1, in
order to get a result in C1.
It is complicated but the whole date in A1 I use it for 2 other purposes.
and I need the year that happened to show in B1 in order to get a result in
C1.
Also is a long data, but having A1,B1 I'll just copy down the formulas.
THANKS.

 

[Gary''s Student]

=YEAR(A1)

 

[Ragdyer]

Several ways to go, depending on exactly what you're intending to do with it
in C1.

Enter
=A1
In B1, and custom format to
yyyy

Enter
=Text(A1,"yyyy")
In B1

Enter
=Year(A1)
In B1

 

[Learning Excel]

I'll be d... Yes, it works!
THANKS Ragdyer and Gary's Student. Appreciate it.
--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.

Several ways to go, depending on exactly what you're intending to do with it
in C1.

Enter
=A1
In B1, and custom format to
yyyy

Enter
=Text(A1,"yyyy")
In B1

Enter
=Year(A1)
In B1

 

[Ragdyer]

And we appreciate your feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

I'll be d... Yes, it works!
THANKS Ragdyer and Gary's Student. Appreciate it.
--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.

Several ways to go, depending on exactly what you're intending to do with it
in C1.

Enter
=A1
In B1, and custom format to
yyyy

Enter
=Text(A1,"yyyy")
In B1

Enter
=Year(A1)
In B1

--
HTH,

RD

--------------------------------------------------------------------------

-

Please keep all correspondence within the NewsGroup, so all may benefit

!

--------------------------------------------------------------------------

-