With a date in A2

=DATE(YEAR(A2),MONTH(A2),DAY(A2))


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1