View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Connie Martin
 
Posts: n/a
Default Another simple formula needed

In A3 there's a date, in date format: May-24-06. In B3 I would like a
formula that would insert MAY, picking up the month from A3. If the date in
A3 is Apr-18-06, then I would like B3 to yield APR, and so on. Connie