Tip 1: Inserting a static date and/or time.
Current date Select a cell and press CTRL+;
Current time Select a cell and press CTRL+SHIFT+;
Current date and time Select a cell and press then SPACE then CTRL+SHIFT+;
Tip 2: Inserting a date that updates.
Choose the Formulas tab and click the Insert Function command and select the function TODAY.
Alternatively, you can type the formula =today() into a cell.
Tip 3: Displaying a series of dates.
To display the dates for a series of days, in the example shown below we have used Mondays. Type the date for the first Monday, in the cell below insert the date for the second Monday. Highlight both cells and then place your mouse pointer over the bottom right corner of the cell (Fill handle) until the mouse pointer changes to a small black cross. Left click and drag down the number of rows required.
