+ Reply to Thread
Results 1 to 4 of 4

Enter Date into another cell when cell is first populated

  1. #1
    Registered User
    Join Date
    01-12-2012
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    70

    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
    Forum Contributor
    Join Date
    11-21-2017
    Location
    Chorley
    MS-Off Ver
    2013
    Posts
    144

    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
    2010
    Posts
    3,298

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

    Try
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    01-12-2012
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    70

    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)

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