• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / Archives for Formulas

How to Compare Dates in Excel

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

LIVE Currency Exchange Rate in Excel

The rich data types make it easy to get a live currency exchange rate in Excel. You can then convert currencies with an Excel formula that updates when the exchange rate changes.

[Read more…] about LIVE Currency Exchange Rate in Excel

N Function in Excel

The N function returns a number when given a value. This tutorial breaks down the N function in Excel and then shows two real-world examples of using it with the SUMPRODUCT function.

You can download the Excel workbook to follow along.

[Read more…] about N Function in Excel

Non-Adjacent Columns with FILTER Function

This tutorial will return non-adjacent columns with the FILTER function. Dynamic array functions such as FILTER and SORT can only return consecutive columns natively. However, there are various methods to specify the columns to return from the array. Functions such as CHOOSECOLS, CHOOSE and INDEX are wonderful for this task.

You can download the Excel workbook to follow along

[Read more…] about Non-Adjacent Columns with FILTER Function

Moving Average 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
  • « Go to Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • Interim pages omitted …
  • Page 19
  • Go to Next Page »

Primary Sidebar

Recent Posts

  • Excel SWITCH Function – Nested IF Function Alternative
  • Sum Formulas Only in Excel
  • How to Calculate Age in Excel
  • Custom Sort in Excel
  • Case Sensitive Lookup with XLOOKUP in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

LinkedIn Twitter YouTube

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Blog
  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2009 Computergaga · All Rights Reserved ·