Getting results of a formula string in a different cell

[Hall]

Cell A1 has the formula =CONCATENATE("=","today","()") and shows =today() as
a string.

I want A2 to refer to A1 and show the results of that formula string. That
is, it should show the current date.

How is that done?

 

[Peo Sjoblom]

You can't, you need VBA

Laurent Longre has an add-in that is free where you can use a function
called EVAL

=EVAL(CONCATENATE("=","today","()"))

will return the result

http://xcell05.free.fr/

English descriptions

http://www.rhdatasolutions.com/morefunc/


--
Regards,

Peo Sjoblom

(No private emails please)