+ Reply to Thread
Results 1 to 3 of 3

Putting computer date in cell

  1. #1
    Fitz
    Guest

    Putting computer date in 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.



  2. #2
    Jim May
    Guest

    Re: Putting computer date in cell

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

    "Fitz" <[email protected]> wrote in message
    news:[email protected]...
    > 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.
    >




  3. #3
    Rowan Drummond
    Guest

    Re: Putting computer date in 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.
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1