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.
|