Top 7 Tricks of Working with Dates in Excel

Top 7 Tricks of Working with Dates in Excel

Top 7 Tricks for Working with Dates in Excel

How to work with Dates in Excel?

Dates and times are two of the most common data types people work within Excel, but they are also possibly the most frustrating to work with, especially if you are new to Excel and still learning. Here is the definitive guide to working with dates in Excel:


The TODAY function always returns the current date’s serial number. The TODAY function is just entered as: =TODAY().

There’s also Excel shortcut that would make the today’s date appear in the cell. “Ctrl+;” would do that trick for you.

A similar function called NOW always returns the current date and time’s serial number. The NOW function is just entered as =NOW().

Excel shortcut that would make current time appear in the cell is “Ctrl +:”.


NETWORKDAYS returns the number of working days between dates.


WEEKDAY returns a number from 1 to 7 identifying the day of the week of a date.


DATEDIF calculates the number of days, months or years between two dates. Excel doesn’t show this formula in the list, so you have to type the whole function and use parenthesis to make the formula work. The screenshots below will give you an idea of how the function works.

Operation with dates in Excel

You can also do operations with dates, for example, subtract as shown in the example below.


EDATE returns a date that is a specific number of months before or after a supplied start date.


There’s so much you can do working with dates in Excel, it’s an infinite topic. But the tips and tricks covered in this blog would help you with the most frequent tasks regarding dates in Excel. Enjoy!

keySkillset can help you to achieve a higher level of efficiency by using shortcuts. Try our Game for Free and rate our App for Android!


Click here to view the resourceClick here to download the resource
Begin your simulation journey today

Start learning new skills with the help of KeySkillset courses and our learning management system today!