Thread: Need to transform the dates to months
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Need to transform the dates to months
One way ..
With source dates in A1 down (assumed to be real dates)
Then in B1: =TEXT(A1,"mmm 'yy")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dereksmom" wrote:
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
Reply With QuoteReply With Quote