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

Need to transform the dates to months
 

Format cells as: mmm-yy
or
=TEXT(A2,"mmm-yy")


"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

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

Need to transform the dates to months
 

Use a custom format of mmm yy, or if you want text use

=TEXT(A1,"mmm yy")


--
Regards,

Peo Sjoblom


"dereksmom" wrote in message
...
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

Need to transform the dates to months
 

If you want to change the existing dates then re-format them to Custom
Fromat mmm yy

or if you want the apostrophe as well use mmm 'yy

But this shows as with the apostrophe hard up agains the zero so you might
want to include a space:

mmm ' yy

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"dereksmom" wrote in message
...
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