View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bony_tony bony_tony is offline
external usenet poster
 
Posts: 76
Default Year Calculation

Or, if you want the actual value to be 2008, then use =YEAR(A1)

Tony

On Jan 4, 9:20 am, AmyBC wrote:
How can I create a formula to calculate a year based on a date? For
example, I have a cell that includes the following date: 3/1/08. I would
like to create a formula in the adjacent cell that calculates the four digit
year that corresponds with the date: 2008.