Excel shortcuts

10 shortcuts for working with dates in Excel

Dates can be a pain to work with in Excel. They're often entered in an incorrect format, or they may be in a different language. Here are 10 shortcuts to help you work with dates in Excel:

  1. To enter the current date: Press Ctrl+; (semicolon).
  2. To enter the current time: Press Ctrl+: (colon).
  3. To change the date format: Select the cells you want to format, then press Ctrl+1. In the Number tab, select the desired format from the Type list.
  4. To change the time format: Select the cells you want to format, then press Ctrl+1. In the Number tab, select the desired format from the Type list.
  5. To insert the current date: Press Ctrl+Shift+; (semicolon).
  6. To insert the current time: Press Ctrl+Shift+: (colon).
  7. To insert the current date and time: Press Ctrl+Shift+; (semicolon), then Ctrl+Shift+: (colon).
  8. To change the date and time formats: Select the cells you want to format, then press Ctrl+1. In the Number tab, select the desired format from the Type list.
  9. To calculate the number of days between two dates: Select the cell where you want the result, then type = (equal sign), followed by the first date, - (minus sign), followed by the second date. For example, to calculate the number of days between 1/1/2015 and 1/31/2015, you would type =1/1/2015-1/31/2015.
  10. To calculate the number of days between two dates in different years: Select the cell where you want the result, then type = (equal sign), followed by the first date, - (minus sign), followed by the second date. For example, to calculate the number of days between 1/1/2015 and 1/1/2016, you would type =1/1/2015-1/1/2016.

These shortcuts should help you work with dates in Excel more efficiently. Do you have any other tips or tricks to share? Let us know in the comments!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.