Hello,
I'm would like to write a function that automatically writes the date an action is taken. In other words, it would be something like:
=IF(D12="x";TODAY(); ) but the problem is I need the date to remain as a static value, which is why I can't use TODAY or NOW. I'm stumped because the only way to write a static date that I have found is using the keyboard command CTRL+SHIFT+; and I can't include that sequence in the IF function or in VBA.
If anyone could help me with this I would be really grateful as I've been wrestling with this problem for two whole days without any luck. It seems so simple......
I'm would like to write a function that automatically writes the date an action is taken. In other words, it would be something like:
=IF(D12="x";TODAY(); ) but the problem is I need the date to remain as a static value, which is why I can't use TODAY or NOW. I'm stumped because the only way to write a static date that I have found is using the keyboard command CTRL+SHIFT+; and I can't include that sequence in the IF function or in VBA.
If anyone could help me with this I would be really grateful as I've been wrestling with this problem for two whole days without any luck. It seems so simple......