| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can Excel automatically insert current date in a cell?
Is there a way to use only the day of the date in this manner. Trying to have
an occurance all ways on th 15th of month year after year Thanks "Paul D. Simon" wrote: While neither a formula solution nor an automated method, simply doing Ctrl+; (in other words, holding down the Ctrl key while hitting the semi-colon) will enter the current date as a static (non-changing) date into the active cell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert date automatically | Excel Discussion (Misc queries) | |||
| Excel formula with date constraints | Excel Discussion (Misc queries) | |||
| Challenging Charting | Charts and Charting in Excel | |||
| Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
| Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) | |||
Threaded Mode
