Add current date to a cell

[mrdata]

Hi.

I want to be able to to mark cell C2 with an "X" and have cell B2 display the current date And Cell A2 display "Ordered".

I thought I had this working but the dates all change when the system date changes.

Charles

[dominicb]

Good afternoon mrdata

The shortcut combination to add todays date in a cell as a static (ir non changing) value is :
Ctrl + ;

HTH

DominicB

[mrdata]

Good afternoon mrdata

The shortcut combination to add todays date in a cell as a static (ir non changing) value is :
Ctrl + ;

HTH

DominicB

Well what I really wanted was for it to happen when the value x is in cell C2.
You can't incorporate the shortcut in a funtion can you?

Charles

[dominicb]

Hi mrdata

Try putting this into a normal module :

Please Login or Register  to view this content.

Now this formula in A2 :
=IF(C2="x","Ordered","")

...and this formula in B2 :
=IF(C2="x",StaticDate(),"")

HTH

DominicB

[mrdata]

Hi mrdata

Try putting this into a normal module :

Please Login or Register  to view this content.

Now this formula in A2 :
=IF(C2="x","Ordered","")

...and this formula in B2 :
=IF(C2="x",StaticDate(),"")

HTH

DominicB

That works great! thank you so very much

Charles

[mrdata]

That works great! thank you so very much

Charles

I thought the code worked but now my dates are changing to the current date instead of staying static.
When I change the system date the dates stay the same but somehow they changed by themselves.

I can't replicate the problem or I would show you.

Charles

[mrdata]

Hi mrdata

Try putting this into a normal module :

Please Login or Register  to view this content.

Now this formula in A2 :
=IF(C2="x","Ordered","")

...and this formula in B2 :
=IF(C2="x",StaticDate(),"")

HTH

DominicB

What would make the dates stay static on one computer but on another change as if no code was there.
The same workbook is on two systems the code works fine on one but not the other both have the exact same version of office.

Could it be a setting in excel?

Charles