Obtaining just the Year out of the date
 

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.

Obtaining just the Year out of the date
 

=YEAR(A1)
--
Gary''s Student - gsnu200788

Obtaining just the Year out of the date
 

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.

Obtaining just the Year out of the date
 

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.

Obtaining just the Year out of the date
 

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.