You can use this in A2

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Cactus1993" wrote in message oups.com...
Today is 07/29/2006, and I've entered that into cell A1 using the
formula =now()
In cell A2, I want to return the first day of the current year (i.e.
01/01/2006).
Is there an Excel formula you can create to do this, so that annual
spreadsheets can automatically updated using the =now() function as a
base date?
Thanks.