![]() ![]() To insert today’s date as a dynamic date, enter the following into an empty cell and tap Enter:.You will use a formula – the “TODAY” and “NOW” functions – to return a dynamic date or time. Sometimes you may want to insert a date or time whose value is updated automatically. Want them both? Static date AND time? Press Ctrl+ (semi-colon), then press Space, and then press Ctrl+Shift+ (semi-colon). To insert the current date, press Ctrl+ (semi-colon).īonus! Need to insert the current time and keep it static? Press Ctrl+Shift+ (semi-colon).On a worksheet, select the cell into which you want to insert the current date. ![]() Posted in: Microsoft or Windows, Tech TipsĪ static value in an Excel worksheet is one that doesn’t change when a formula or worksheet is recalculated or opened.
0 Comments
Leave a Reply. |