Everyone works with dates in Excel. Often a spreadsheet will contain multiple date columns. And a common question is “how to compare dates in Excel?”.

In this tutorial, we explain how dates are stored in Excel and see many examples of comparing dates including the use of numerous functions from our Excel functions list.

Download the sample file to follow along with the practical examples.

How does Excel Store Dates in the Cells?

Excel stores dates as whole numbers known as serial numbers. Each day, one is added to the serial number of the previous date.

For example, the Excel date, or serial number, for the 1st May 2023 is 45047.

[Read more…] about How to Compare Dates in Excel

This tutorial will look at how to calculate moving average in Excel. The moving average is sometimes referred to as the rolling average as it averages the values from a rolling, or moving, date range. In this post, our focus is on a seven-day moving average.

You can download the Excel workbook used in this tutorial to follow along.

[Read more…] about Moving Average in Excel