View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Learning Excel Learning Excel is offline
external usenet poster
 
Posts: 98
Default 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.