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!