View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kennedy kennedy is offline
external usenet poster
 
Posts: 24
Default Converting Date 03/01/2010 into a simple Month

Is there a way to convert a numeric date 03/01/2010 into a single month
function? I have a worksheet that pulls in data from another worksheet, and
column A has a numeric date of 03/01/2010. Want to put a statement in column
B or where that only shows the month instead of the whole date field.