Thread: Breaking down a cell to create a function
View Single Post
  #3  
Old April 17th, 2009, 09:16 PM posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
  
Posts: 3,722
Default Breaking down a cell to create a function
=YEAR(A1)

"Robert" wrote:

I'm trying to create a flow graph by using current information on my
spreadsheet. I have a column of dates in this format 01/05/06. I trying to
find a formula that will only use the year in that format, so I can show
trends by the year. Please help! I've been trying this for a week and can't
figure it out. And I don't even know if it's possible.