You can use following formula in adjacent cell=
=DATE(YEAR(H1),MONTH(H1)-1,DAY(H1))



Chris
------
Convert your Excel spreadsheet into online calculator.
http://www.spreadsheetconverter.com

--
Message posted via http://www.officekb.com