Tools
You are here: Home » Blog » Microsoft Excel Tips: Date and Time
Thursday, 28 Mar 2024

Microsoft Excel Tips: Date and Time

 

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.

 



Share this article
 social bookmarker

Add comment


Security code Refresh

Contact Us

Telephone : 0117 929 1509
Send us a message or request a call back

1000 characters left