Excel shortcuts

15 Excel Shortcuts for Dates You Need to Know

If you work with dates in Excel, you know how frustrating it can be to try and remember all the different functions and formulas. Even if you're just trying to enter a simple date, it can be a challenge to remember the right format. Luckily, there are a few shortcuts that can help make working with dates a little easier. Here are 15 Excel shortcuts for dates you need to know:

1. To enter the current date, simply press Ctrl+;. This shortcut will insert the current date in the format that is set in your regional settings. For example, if your regional settings are set to United States, the current date will be inserted as mm/dd/yyyy. If you want to change the format of the date, you can do so by selecting the cell and then going to Format Cells under the Home tab.

2. To enter the current time, press Ctrl+Shift+;. This shortcut will insert the current time in the format that is set in your regional settings. For example, if your regional settings are set to United States, the current time will be inserted as h:mm:ss AM/PM.

3. To insert the current date and time, press Ctrl+Shift+; and then press Ctrl+;. This shortcut will insert the current date and time in the format that is set in your regional settings. For example, if your regional settings are set to United States, the current date and time will be inserted as mm/dd/yyyy h:mm:ss AM/PM.

4. To quickly insert a specific date, use the DATE function. For example, to insert January 1, 2015, you would use the following formula: =DATE(2015,1,1). You can also use this function to insert the current date by using the TODAY function. For example, the following formula would insert the current date: =TODAY().

5. To quickly insert a specific time, use the TIME function. For example, to insert 12:00:00 AM, you would use the following formula: =TIME(0,0,0). You can also use this function to insert the current time by using the NOW function. For example, the following formula would insert the current time: =NOW().

6. To add days, months, or years to a date, you can use the DATE function. For example, to add 5 days to a date, you would use the following formula: =DATE(year,month,day+5). To add 1 month to a date, you would use the following formula: =DATE(year,month+1,day). And to add 1 year to a date, you would use the following formula: =DATE(year+1,month,day).

7. To subtract days, months, or years from a date, you can use the DATE function. For example, to subtract 5 days from a date, you would use the following formula: =DATE(year,month,day-5). To subtract 1 month from a date, you would use the following formula: =DATE(year,month-1,day). And to subtract 1 year from a date, you would use the following formula: =DATE(year-1,month,day).

8. To calculate the number of days between two dates, you can use the DAYS function. For example, the following formula would calculate the number of days between January 1, 2015 and January 10, 2015: =DAYS(DATE(2015,1,1),DATE(2015,1,10)).

9. To calculate the number of months between two dates, you can use the MONTHS function. For example, the following formula would calculate the number of months between January 1, 2015 and January 10, 2015: =MONTHS(DATE(2015,1,1),DATE(2015,1,10)).

10. To calculate the number of years between two dates, you can use the YEARS function. For example, the following formula would calculate the number of years between January 1, 2015 and January 10, 2015: =YEARS(DATE(2015,1,1),DATE(2015,1,10)).

11. To calculate the number of days until a certain date, you can use the DAYS function. For example, the following formula would calculate the number of days until January 10, 2015: =DAYS(TODAY(),DATE(2015,1,10)).

12. To calculate the number of months until a certain date, you can use the MONTHS function. For example, the following formula would calculate the number of months until January 10, 2015: =MONTHS(TODAY(),DATE(2015,1,10)).

13. To calculate the number of years until a certain date, you can use the YEARS function. For example, the following formula would calculate the number of years until January 10, 2015: =YEARS(TODAY(),DATE(2015,1,10)).

14. To calculate the number of days since a certain date, you can use the DAYS function. For example, the following formula would calculate the number of days since January 10, 2015: =DAYS(DATE(2015,1,10),TODAY()).

15. To calculate the number of months since a certain date, you can use the MONTHS function. For example, the following formula would calculate the number of months since January 10, 2015: =MONTHS(DATE(2015,1,10),TODAY()).

These are just a few of the many shortcuts you can use when working with dates in Excel. While they may not cover every possible scenario, they should help make working with dates a little easier. Do you have a favorite date shortcut? Share it in the comments below.

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.