Are you saying that you want text instead of the date, or do you want the
date to be changed to 1/1/2007 formatted as 1/2007?
=TEXT(A1,"m/yyyy")
=DATE(YEAR(A1),MONTH(A1),1) and format as m/yyyy
--
David Biddulph

"charlie" wrote in message
...
I want to extract day out of 1/31/2007 and have only 1/2007 left in the
cell
after