Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date functions
I would like to use a function like TODAY(), but the problems is that tha date isn't static....that means i would like to have a function that cointains the date on that date when the document is created.... 10x 4 help -- excelpomoc ------------------------------------------------------------------------ excelpomoc's Profile: http://www.excelforum.com/member.php...o&userid=27242 View this thread: http://www.excelforum.com/showthread...hreadid=467511 |
#2
|
|||
|
|||
There is no function that will do what you ask. It can be done using VBA code. Are you interested in that type of a solution? -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=467511 |
#3
|
|||
|
|||
Create a UDF that returns:
activeworkbook.BuiltinDocumentProperties("creation date") -- Gary''s Student "excelpomoc" wrote: I would like to use a function like TODAY(), but the problems is that tha date isn't static....that means i would like to have a function that cointains the date on that date when the document is created.... 10x 4 help -- excelpomoc ------------------------------------------------------------------------ excelpomoc's Profile: http://www.excelforum.com/member.php...o&userid=27242 View this thread: http://www.excelforum.com/showthread...hreadid=467511 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Complex Date Functions | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions | |||
Date functions for dates pre-1900 | Excel Discussion (Misc queries) | |||
Date functions | Excel Discussion (Misc queries) |