To both Rons:

Thanks, guys. Both formulas work, and I can see using each in different
instances in my Excel program. Probably simple enough for you guys ...
but I was wrestling with it because I'm not well versed in date formula
calculations.

Thanks again, and for following up so fast!!!


Ron Coderre wrote:
Try this:

=DATE(YEAR(TODAY()),1,1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Cactus1993" wrote:

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.