Inserting a static date into a function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

So here's what I am trying to do:

I've created a pull-down list with a checkmark and I would like to create a
function for another cell that will insert the date that the checkmark was
added. The tricky part is getting that date to stay static instead of
changing to the computer's date (as with the TODAY() and NOW() functions). I
know that I have to us an IF function (like IF(A1=checkmark, "STATIC DATE",
"") ... and the static date is the thing that is killing me. In addition, my
company's computers do not take kindly to macros, so if there is anyway that
I am able to do this through a function, that would be ideal. Thanks!
 
This can't be done with a formula. You would need to use a Macro or have the
user manually input the date. Note, a shortcut to input the current date is
CTRL+;

HTH,
Elkar
 
What about putting the "CTRL+;" into the function ... is there a way to
"functionate" that phrase?
 
This method does work, but be careful using it. The Iterations setting has a
habit of turning itself back off if you have a different workbook open prior
to opening this one. This should not affect any timestamps already in place,
but could prevent future timestamps from being applied accurately.

HTH,
Elkar
 
Elkar

Good point.

I personally would not use this method, preferring a change event to stamp the
cell.

OP wanted a non-VBA approach but I should have pointed out the caveat as you
did.


Gord
 
Back
Top