Hi Met,

Modify as follows:

sNewName = UCase$(left(monthname(month(date)-1),3)) & " " & year(date)

Regards,
Garry


"Metrazal" wrote:


Done deal...

Thanks..

One more thing:

I need the date to be in the format FEB 2006, I still need the date
to back up one month but abbreviate the date and display the year.

Once again..

Thanks,
Met


--
Metrazal
------------------------------------------------------------------------
Metrazal's Profile: http://www.excelforum.com/member.php...o&userid=31648
View this thread: http://www.excelforum.com/showthread...hreadid=518833