date formula

[Guest]

I need a formula the will update a cell at the start of the year to something
like 1/1/07 for 2007, 1/1/08 for 2008 and so on.
any ideas?

 

[Guest]

Try this,

=DATE(YEAR(NOW()),1,1)

Mike

 

[Guest]

thanks for that help alot

Try this,

=DATE(YEAR(NOW()),1,1)

Mike

 

[Guest]

=YEAR(TODAY()) ???