#1   Report Post  
excelpomoc
 
Posts: n/a
Default 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   Report Post  
swatsp0p
 
Posts: n/a
Default


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   Report Post  
Gary''s Student
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
Complex Date Functions Simon Heaven Excel Worksheet Functions 6 November 6th 09 05:11 PM
search for latest date Sue Excel Worksheet Functions 2 August 2nd 05 11:09 PM
Date functions for dates pre-1900 Stephen Larivee Excel Discussion (Misc queries) 2 July 20th 05 08:23 PM
Date functions Dale Excel Discussion (Misc queries) 5 April 10th 05 01:45 PM


All times are GMT +1. The time now is 09:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"