+ Reply to Thread
Results 1 to 2 of 2

How to auto enter today's date into cells

  1. #1
    Forum Contributor
    Join Date
    12-07-2013
    Location
    Staten Island, New York
    MS-Off Ver
    Excel 2010
    Posts
    106

    How to auto enter today's date into cells

    Hi everyone. I'm looking to set up a bunch of cells so that when data is put into them and you hit ENTER, today's date and a dash automatically appear before the text typed.

    As an example, if I type "filed tax return" into a cell and hit ENTER, I want the cell to then say "March 9 - filed tax return"

    I'm just looking for it to display the month and day (but not year), although if I could be shown how to do both (making it display just month and day, and also making it display month, day, and year) that would be great.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,403

    Re: How to auto enter today's date into cells

    How about a button on your spreadsheet that puts the data in whatever cell is highlighted/activated?

    Insert a button on your spreadsheet and attach this code to the button

    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)

Similar Threads

  1. [SOLVED] Auto Fill Cell With Today's Date And Shift Cells To The Right
    By EricBarnes88 in forum Excel General
    Replies: 9
    Last Post: 02-06-2014, 09:26 AM
  2. [SOLVED] how to enter today's date into cell
    By johnandrews in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2014, 04:44 AM
  3. Replies: 3
    Last Post: 06-01-2008, 04:55 PM
  4. to enter today's date if a cell is blank
    By Lynn Hanna in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-26-2006, 08:10 AM
  5. [SOLVED] in excel how do enter today's date on a laptop
    By bency in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-29-2005, 05:05 PM

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