auto update date

[NuWest]

is there a way that i can have the date in a cell automatically updated to the current date?
thanks.

 

[Barry Katcher]

Enter this in a cell:

=NOW()

this will place the date and time in the cell and will be updated every time you enter anything into any other cells in the sheet.

 

[NuWest]

Thanks from an novice exceler!