Putting computer date in cell

[Fitz]

How do I get excel to put the current date (ie.computer date) in a specific
cell so that each time I open the file the current date is in that
particular cell.

 

[Jim May]

=today() < for day only
or
=Now() for day and time

 

[Rowan Drummond]

=Today()

This is a volatile function so it will be recalculated everytime the
file is opened, closed or any other operation triggers calculation.

Hope this helps
Rowan