| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date and Time Stamp in Excel
Ok, I know to most of you this question is really simple,
but I've had NO formal training with Excel and am learning as I go! What are the formula's to have a spread sheet AUTOMATIALLY update the date and time each time you open the file? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date and Time Stamp in Excel
Just to add:
Those will also update each time the sheet is recalculated. -- Regards, Tom Ogilvy "Paul B" wrote in message ... Todd, =NOW() will give you the date and time, =TODAY() will give you the date -- Paul B Always backup your data before trying something new Using Excel 2000 & 97 Please post any response to the newsgroups so others can benefit from it ** remove news from my email address to reply by email ** "Todd" wrote in message ... Ok, I know to most of you this question is really simple, but I've had NO formal training with Excel and am learning as I go! What are the formula's to have a spread sheet AUTOMATIALLY update the date and time each time you open the file? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove time stamp from date in excel | Excel Worksheet Functions | |||
| permanent time and date stamp for Excel --- so it cant be changed | Excel Discussion (Misc queries) | |||
| EXCEL GLOBAL DATE AND TIME STAMP | Excel Discussion (Misc queries) | |||
| Add time and date stamp to Excel comments. | Excel Discussion (Misc queries) | |||
| can you date time stamp entries in excel | Excel Discussion (Misc queries) | |||
![Todd[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
