Trying to update some old macro code for a customer. This used to work (they claim) but now returns "Year to Date As of 1/31/1900"

="Year to Date As of " &TEXT(EOMONTH(6/1/2011,0), "mm/dd/yyyy" )

Thanks.............SRC