The function used assumes the first date to be in A1, change the cell address
as needed.

Insert a blank column to the right of your dates as a helper column.

In the first row enter the following formula:

=TEXT(MONTH(G9),"#0")&"/"&TEXT(YEAR(G9),"0000")

Copy down the length of the column. Then copy the column of dates you've
just created with the formula. Move to cell A1 and do an EDIT/PASTE SPECIAL
and select values.

Your dates have been replaced with the values the formula produced. Delete
the helper column when done.
--
Kevin Backmann


"charlie" wrote:

I want to extract day out of 1/31/2007 and have only 1/2007 left in the cell
after