+ Reply to Thread
Results 1 to 2 of 2

Make TODAY() not change tomorrow?

  1. #1
    Registered User
    Join Date
    06-04-2014
    MS-Off Ver
    2013
    Posts
    15

    Make TODAY() not change tomorrow?

    How do I make this formula, when it activates today's date not change tomorrow?

    =IF(U4>0,TODAY(),IF(U4="",TODAY(),""))

  2. #2
    Forum Contributor
    Join Date
    07-29-2014
    Location
    Oz
    MS-Off Ver
    2010
    Posts
    142

    Re: Make TODAY() not change tomorrow?

    You can't with formulas unless you hard code the date into it i.e. =IF(U4>0,DATE(2015,1,23) ..... etc. You could have a macro insert the result of the formula for you, and then it will just be the value, not the formula. By the way, you can abbreviate this a little with OR =IF(OR(U4>0,U4=""),DATE(2015,1,23),"")

    Dan
    Don't forget to ☆ me if I helped you!

+ 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. Replies: 6
    Last Post: 09-29-2014, 12:35 PM
  2. Replies: 8
    Last Post: 09-26-2014, 03:51 PM
  3. [SOLVED] Can I make a cell display something if any date in a row is before today?
    By Deathwing in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-10-2014, 04:46 PM
  4. Make TODAY() stay the same date
    By danison in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-02-2010, 07:47 PM
  5. How to make the Result of a TODAY Function static?
    By kscramm in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-23-2006, 04:20 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