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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Learning Excel" wrote in message
...
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.


"Ragdyer" wrote:

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
!

--------------------------------------------------------------------------
-
"Learning Excel" wrote in
message
...
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.

--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.