Cactus1993:

Try this

=A1-(A1-DATE(YEAR(A1),1,1))

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=566337