Date functions

[excelpomoc]

I would like to use a function like TODAY(), but the problems is tha
tha date isn't static....that means i would like to have a functio
that cointains the date on that date when the document is created....


10x 4 hel

 

[swatsp0p]

There is no function that will do what you ask. It can be done usin
VBA code. Are you interested in that type of a solution

 

[Guest]

Create a UDF that returns:

activeworkbook.BuiltinDocumentProperties("creation date")