| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show current date in cell
Put this in a cell:
=today() Give it a nice date format. Alex01 wrote: Please can someone tell me how to format a cell to show current date each time a sheet is opened? thanks in advance -- Alex01 ------------------------------------------------------------------------ Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311 View this thread: http://www.excelforum.com/showthread...hreadid=516232 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if data in one cell, then date in adjacent cell | Excel Worksheet Functions | |||
| Show week number in current month | Excel Discussion (Misc queries) | |||
| How do I get a cell to show the day of the week when date entered | Excel Discussion (Misc queries) | |||
| How do I show file creation date in a cell in Excel? | Excel Worksheet Functions | |||
| Extracting data from the current date | Excel Worksheet Functions | |||
Hybrid Mode
