View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ben McBen[_2_] Ben McBen[_2_] is offline
external usenet poster
 
Posts: 14
Default Extracting the Month from the Date in other cell

Remeber that these are really numbers (well I hope they
are) You can either covert these to a month by entering a
formula:

=TEXT(A1,"MMM") - short month name
=TEXT(A1,"MMMM") - full month name


Or you could use a custome format ad just type MMM or MMMM
into the input field in the format cells, number, custom.