Although this formula works, it may not be the most efficient:

=A1-(A1-DATE(YEAR(A1),1,1))
is the same as:
=A1-A1+DATE(YEAR(A1),1,1))
or
=DATE(YEAR(A1),1,1)



Flintstone wrote:

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

--

Dave Peterson