+ Reply to Thread
Results 1 to 5 of 5

Want to display current date if a cell is empty

  1. #1
    Registered User
    Join Date
    03-26-2020
    Location
    alberta,canada
    MS-Off Ver
    MS office 365 proplus
    Posts
    3

    Want to display current date if a cell is empty

    I have to keep records of when job tasks are complete. If they are done put in a date. But if they are not complete they have a blank space and I want the current date to be displayed there as I will need it for some other statistical data my boss wants me to track. the list has around 4700 lines entered so far.Excel level - Beginner

    Thanks in advance.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Want to display current date if a cell is empty

    See the yellow banner at the top of the page.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    03-26-2020
    Location
    alberta,canada
    MS-Off Ver
    MS office 365 proplus
    Posts
    3

    Re: Want to display current date if a cell is empty

    Trying to attach. Not sure how to execute it but will try.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Want to display current date if a cell is empty

    Right Click on the sheet name at the bottom of excel and paste this code into the module that opens and close it.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 03-26-2020 at 09:05 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  5. #5
    Registered User
    Join Date
    03-26-2020
    Location
    alberta,canada
    MS-Off Ver
    MS office 365 proplus
    Posts
    3

    Re: Want to display current date if a cell is empty

    hmmmm...opened this up and it did not seem to work for what I was doing. This code you have written seems a lot more detailed than I thought it would be to achieve what I was looking for. Thanks for trying though.

+ 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 not empty, display today's date in adjoining cell
    By jmueller0823 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-22-2019, 11:05 AM
  2. Replies: 6
    Last Post: 01-06-2017, 05:31 PM
  3. Difference in NETWORKDAYS, but to current date if cell is empty
    By Dan.Reynolds in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-22-2013, 05:59 PM
  4. [SOLVED] Display Current Date With Specific Formatting In Cell Only Once
    By swordswinger710 in forum Excel Programming / VBA / Macros
    Replies: 39
    Last Post: 03-02-2012, 12:49 PM
  5. Adding current date in next empty cell
    By Crüe in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-15-2011, 08:39 AM
  6. If Cell is Empty create rule to Display the current Date
    By Sidewinder in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-05-2007, 04:12 PM
  7. How do I code a cell to display the current date on double-click?
    By George in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2005, 01:06 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