Being able to subtract a date from today is a great way to accurately calculate the number of days between dates. Read: How to stop Excel from rounding numbers. What does the ABS function in Excel do?

In Excel, every date is stored as a serial number, starting from January 1, 1900, which is serial number 1. So, January 2, 1900, is serial number 2, January 3, 1900, is serial number 3, and so on.

The WEEKDAY() function returns TRUE for weekend dates in Excel. Now that we know what function we’ll use to set a conditional format, let’s do so. How to apply the rule online in Excel.

Excel’s Date filters are very comprehensive and allow you to extract individual or multiple dates by day, week, month, year, quarter, or year-to-date, plus dates within ranges.

Depending how you use these dates, you might want to highlight specific dates as they approach the current date in Microsoft Excel. Similarly, you might want to highlight future dates.

How to change the date format in Microsoft Excel. We're using a spreadsheet that includes dates of hire for employees of a fictitious company, to show different ways to format dates in Excel. 1.

Using an Excel spreadsheet you can input the dates and descriptions of these events in a random order and then reorganize your spreadsheet data by date. Input your events into Excel.