+ Reply to Thread
Results 1 to 7 of 7

enter todays date

  1. #1
    Forum Contributor
    Join Date
    07-10-2008
    Location
    UK
    Posts
    220

    enter todays date

    Hi Guys,

    How do I enter todays date, firstly into a cell in a sheet.

    secondly into the first cell of a table in word...the table has one row, two columns?

    any ideas?



    also not sure if i need to start a new thread for this....how to i get the filename of the workbook to go into the second cell of that table in word?

  2. #2
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    157

    Re: enter todays date

    I'm not sure how to do it in Word, but in Excel you can use the "today" function.

    Put this fomula into any cell you want to display todays date.
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: enter todays date

    Ctrl +; will also do the trick

  4. #4
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    157

    Re: enter todays date

    Quote Originally Posted by arthurbr View Post
    Ctrl +; will also do the trick
    I like that little trick. I'll have to remember that. Thanks!

  5. #5
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: enter todays date

    Quote Originally Posted by Ricker090 View Post
    I like that little trick. I'll have to remember that. Thanks!
    You're welcome. Be aware XL has lots of shortcut keys available

  6. #6
    Forum Contributor
    Join Date
    07-10-2008
    Location
    UK
    Posts
    220

    Re: enter todays date

    thanks guys, but I was looking to add this onto a current bit of code, so need a macro to set which cell, sheet etc and then put the date there...

  7. #7
    Valued Forum Contributor
    Join Date
    09-21-2003
    Location
    British Columbia , Canada
    MS-Off Ver
    03,07,10,13
    Posts
    727

    Re: enter todays date

    thanks guys, but I was looking to add this onto a current bit of code, so need a macro to set which cell, sheet etc and then put the date there...
    Please Login or Register  to view this content.

+ 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