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