| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Current Date on a Sheet 1 Tab | Excel Worksheet Functions | |||
| I can't insert a worksheet into my current spreadsheet file | Excel Worksheet Functions | |||
| Insert Current Date when cell is empty?? | Excel Worksheet Functions | |||
| Any quick key to insert current Date and Time? | Excel Discussion (Misc queries) | |||
| How to insert a current date | Excel Discussion (Misc queries) | |||
Linear Mode
