date formula

[Dreamstar_1961]

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?

 

[Mike]

Try this,

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

Mike

 

[Dreamstar_1961]

thanks for that help alot

Try this,

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

Mike

 

[Dave F]

=YEAR(TODAY()) ???