Make a cell contain first day of current year no matter what actual date is

[Gadgetman]

I'm wondering if there is a way to make a cell contain the first day of
the current year no matter what day/date is and then update itself when
the calendar year changes.

For example... I want a cell to contain 1/1/11 for this year and have it
update next year to 1/1/12 in 2012 and so on.

Thanks for any help

 

[Claus Busch]

Hi,

Am Fri, 17 Jun 2011 15:26:05 -0400 schrieb Gadgetman:

For example... I want a cell to contain 1/1/11 for this year and have it
update next year to 1/1/12 in 2012 and so on.

try this:
=DATE(YEAR(TODAY()),1,1)


Regards
Claus Busch

 

[Gadgetman]

Thank you Claus. Worked for me!