Thread: Date question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jman Jman is offline
external usenet poster
 
Posts: 110
Default Date question

I have in column A numbers 1-12 all representing the months in a year.
When i put in this formula =month(B1)
i get the numbers of the months... Is there a formula that gives me only the
NAME of the month, NOT the number.

A1 equals "2" how can this number be changed to say "feb" instead of 2?
B1 2-04-07