+ Reply to Thread
Results 1 to 3 of 3

Auto Populate today date in cells

  1. #1
    Forum Contributor
    Join Date
    02-12-2014
    Location
    al ain
    MS-Off Ver
    Excel 2016
    Posts
    149

    Cool Auto Populate today date in cells

    Hi All,
    e.i. What ever I type in the 'Activity', I want to auto populate today's date in the 'Date' column.
    I have the Today() formula in the 'Date' but it changes the values as dates changes.
    I mean whatever I type today in the Activity, the Date must return today's date. but tomorrow and on wards It must not change and remain still.
    Thanks.
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    2013, 2016
    Posts
    318

    Re: Auto Populate today date in cells

    Hi,

    Try this:
    =IF(ISBLANK(A6),"",TEXT(TODAY(),"dd.mm.yyyy")) change dd.mm.yyyy to mm.dd.yyyy if need.

  3. #3
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Auto Populate today date in cells

    Hi

    See this http://www.exceltrick.com/formulas_m...tamp-in-excel/

+ 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] Automatically populate today's date
    By mattmc419 in forum Excel General
    Replies: 6
    Last Post: 10-10-2014, 01:00 PM
  2. How to auto enter today's date into cells
    By Curious Dude in forum Excel General
    Replies: 1
    Last Post: 03-09-2014, 12:43 PM
  3. [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
  4. [SOLVED] Listbox in userform to populate with all rows containing the Date today AND 2 weeks prior
    By cath1509 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-05-2013, 08:50 PM
  5. Auto Populate different Cells depending on date entered
    By jpjb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 11:12 AM
  6. [SOLVED] help!! Need Sheet2 to auto populate with dates that are today's date or 90 days out
    By JennK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-30-2012, 07:33 PM
  7. Auto-populate Today's Date?
    By Ocean Zhang in forum Excel General
    Replies: 1
    Last Post: 03-12-2011, 11:23 AM

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