create a spreadsheet that would insert a current date() when opene
 

Create a spreadsheet that would insert the current date into a cell or
expression when opened.

For example the cell would be something like...
[The membership roster as of Date()]

and would display "The membership roster as of Jan. 16, 2008"

when opened on Jan. 16, 2008.

create a spreadsheet that would insert a current date() when opene
 

Just use a plain old formula:

="The membership roster of " & text(today(), "mmmm dd, yyyy")

Testudo wrote:

Create a spreadsheet that would insert the current date into a cell or
expression when opened.

For example the cell would be something like...
[The membership roster as of Date()]

and would display "The membership roster as of Jan. 16, 2008"

when opened on Jan. 16, 2008.


--

Dave Peterson

create a spreadsheet that would insert a current date() when o
 

Thanks a million:

Your solution works great. (As you can tell I am not exactly an Excel GURU.)

Thanks again!



"Dave Peterson" wrote:

Just use a plain old formula:

="The membership roster of " & text(today(), "mmmm dd, yyyy")

Testudo wrote:

Create a spreadsheet that would insert the current date into a cell or
expression when opened.

For example the cell would be something like...
[The membership roster as of Date()]

and would display "The membership roster as of Jan. 16, 2008"

when opened on Jan. 16, 2008.


--

Dave Peterson