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.
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.
=today() < for day only
or
=Now() for day and time
"Fitz" <fitz1@sympatico.ca> wrote in message
news:9hW6f.2818$Nj3.163158@news20.bellglobal.com...
> 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.
>
=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
Fitz wrote:
> 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.
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks