use CTRL key inside a formula
"Gord Dibben" wrote:
Not inside a formula.
What do you want in B2?
If today A2 equals "Yes" you want the date in B2?
If tomorrow A2 < "Yes" what do you want to see in B2.........nothing?
If next Thursday A2 goes back to "Yes" should value of B2 change to that date?
I think you will have to resort to event code.
Gord Dibben MS Excel MVP
On Mon, 14 Apr 2008 16:03:00 -0700, Date Less
wrote:
use CTRL key + ; inside a formula to put the static date in B2 If a2 = YES
if(a2="yes",today(),"blank") the date changes I want to replace today() with
CTRL ;
The formula will be in b2. I have a drop down box in a2 'yes and no' if the user chooses yes then I want the static date in b2 if the user chooses no the I will leave b2 blank. I did use Today() last week on Friday the 11th and today when I opened the XLS document the date changed to the 14th. The research I have found so far is that <CTRL + ; puts in a static date.
|