+ Reply to Thread
Results 1 to 7 of 7

[SOLVED] Fill cell with today's date

  1. #1
    Sarahbkelly
    Guest

    [SOLVED] Fill cell with today's date

    Is there a way to automatically fill a cell with todays date?

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    Use

    =TODAY()

  3. #3
    pinmaster
    Guest

    RE: Fill cell with today's date

    Hi,

    =TODAY()

    Regards
    JG

    "Sarahbkelly" wrote:

    > Is there a way to automatically fill a cell with todays date?


  4. #4
    Gord Dibben
    Guest

    Re: Fill cell with today's date

    =TODAY()

    Note: this will update every new day.

    If you want a static date just hit CTRL + ;


    Gord Dibben MS Excel MVP

    On Thu, 19 Jan 2006 14:40:02 -0800, "Sarahbkelly"
    <Sarahbkelly@discussions.microsoft.com> wrote:

    >Is there a way to automatically fill a cell with todays date?



  5. #5
    Roger Govier
    Guest

    Re: Fill cell with today's date

    Hi Sarah

    You have 2 answers giving you =TODAY(), which is quite correct.
    Obviously this will change when you open the file tomorrow.
    if you just wanted to insert today's date into a cell and have it fixed,
    then type Ctrl ; (Control + semicolon)

    --
    Regards

    Roger Govier


    "Sarahbkelly" <Sarahbkelly@discussions.microsoft.com> wrote in message
    news:C1280798-9D25-47F6-82D2-EA08DED7C3DC@microsoft.com...
    > Is there a way to automatically fill a cell with todays date?




  6. #6
    Registered User
    Join Date
    01-19-2006
    Posts
    1

    I need to print the timestamp also along with the date

    I need to print the timestamp also along with the date

  7. #7
    Roger Govier
    Guest

    Re: Fill cell with today's date

    Hi

    Then type Ctrl+; then a space then Ctrl +: (Ctrl + semicolon space Ctrl
    + colon)

    --
    Regards

    Roger Govier


    "astronautt" <astronautt.21wnfn_1137713100.9047@excelforum-nospam.com>
    wrote in message
    news:astronautt.21wnfn_1137713100.9047@excelforum-nospam.com...
    >
    > I need to print the timestamp also along with the date
    >
    >
    > --
    > astronautt
    > ------------------------------------------------------------------------
    > astronautt's Profile:
    > http://www.excelforum.com/member.php...o&userid=30652
    > View this thread:
    > http://www.excelforum.com/showthread...hreadid=503118
    >




+ 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