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

G

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
 
C

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.
Click to expand...

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


Regards
Claus Busch
 
Top