View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dereksmom dereksmom is offline
external usenet poster
 
Posts: 7
Default Need to transform the dates to months

I need help with a formula that will lookup the dates into months.

For example, if I have a set of dates in a column:

01/15/07 == Jan '07
02/05/07 == Feb '07
02/13/07 == Feb '07
01/05/06 == Jan '06
04/25/06 == Apr '06

I need a formula that will switch them to the month and year that the date
is within that month and year.

Thanks,

D