Top 7 Tricks of Working with Dates in Excel

 In Uncategorized

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

NETWORKDAYS returns the number of working days between dates.
working with dates in excel

working with dates in excel

WEEKDAY & WEEKNUM

WEEKDAY returns a number from 1 to 7 identifying the day of the week of a date.
working with dates in excel

working with dates in excel

WEEKNUM returns the week number in the year.
working with dates in excel

EDATE

EDATE returns a date that is a specific number of months before or after a supplied start date.
working with dates in excel

working with dates in excel

DATEDIF

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.

working with dates in excel
working with dates in excel

working with dates in excel

Operation with dates

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

working with dates in excel

Summary

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!

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


Calculate in a second

how much time you’ll save with Hot Key excellence

           
           
           
Recent Posts

Leave a Comment

How can we
help you?
Contact Us

Please, leave a message and we'll get back to you asap

Try FREE

Excel Game

top 4 new ways to show data in excelremote excel support