+ Reply to Thread
Results 1 to 4 of 4

Enter Date into another cell when cell is first populated

  1. #1
    Forum Contributor
    Join Date
    01-12-2012
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    104

    Enter Date into another cell when cell is first populated

    Hi all,

    I'm trying to figure out how to show the date when a cell was first populated, rather than changing the date whenever the cell is updated.

    I have the following code, would anyone be able to show me how to alter the code to suit the purpose?

    Please Login or Register  to view this content.
    Thanks in advance.

    Joe
    Last edited by Storm08; 01-14-2019 at 07:48 AM.

  2. #2
    Valued Forum Contributor PaulSP8's Avatar
    Join Date
    11-21-2017
    Location
    Chorley, England
    MS-Off Ver
    2013 & 2021
    Posts
    437

    Re: Enter Date into another cell when cell is first populated

    This will only add a date if the cell is empty, which is what I think you want?

    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Enter Date into another cell when cell is first populated

    Try
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    01-12-2012
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    104

    Re: Enter Date into another cell when cell is first populated

    Quote Originally Posted by Phuocam View Post
    Try
    Please Login or Register  to view this content.
    Thank you Phuocam, that's spot on!

+ 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] If cell meets date requirement enter 1, if not enter 0, if blank don't enter anything.
    By billrogers184 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-11-2017, 02:04 PM
  2. Replies: 11
    Last Post: 01-23-2017, 11:40 AM
  3. Addition of Date When A Cell Is Populated
    By STBTC in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-02-2016, 03:45 PM
  4. Calculate only if cell is populated by a date
    By TYRANNUS CENTRE in forum Excel General
    Replies: 6
    Last Post: 08-25-2014, 05:45 AM
  5. [SOLVED] Populating cell with a date after another cell has been populated
    By coach.32 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2013, 08:23 PM
  6. Macro that changes a cell when another one has a date populated in it.
    By photochic10 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2013, 09:25 AM
  7. [SOLVED] Prompt input of future date in cell when another cell has been populated or modified
    By coffeemints in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2013, 06:46 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