Thread: List
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arne Hegefors Arne Hegefors is offline
external usenet poster
 
Posts: 244
Default List

Hi! I have a long list of dates in column A. IN col B I want to have only the
year of the date in column A. The date is written like: YYYY-MM-DD. How can I
get only the year? Thanks alot!