Top 7 Tricks of 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:
TODAY & NOW
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 & WEEKNUM
WEEKDAY returns a number from 1 to 7 identifying the day of the week of a date.
WEEKNUM returns the week number in the year.
EDATE returns a date that is a specific number of months before or after a supplied start 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
You can also do operations with dates, for example, subtract as shown in the example below.
There’s so much you can do 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 with dates in Excel. Enjoy!