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.

While creating data in an Excel spreadsheet, there might be cases when you need to highlight the rows with dates less than a specific date.

If you intend to obtain a list of all dates or data between two given dates in Excel, then you can Use the Fill handle or use a Formula. Learn how.

If you need a monthly or yearly balance for revenue transactions in Microsoft Excel, you're in luck because both are easy! Here's how to find the totals you need.

How to return a sequence of dates in Excel Excel’s fill handle can generate a quick list of dates for you, but the list is static; you must create a new list if your needs change.