How do I make this formula, when it activates today's date not change tomorrow?
=IF(U4>0,TODAY(),IF(U4="",TODAY(),""))
How do I make this formula, when it activates today's date not change tomorrow?
=IF(U4>0,TODAY(),IF(U4="",TODAY(),""))
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks