DATEDIFF for POWER QUERY

This article gives you the M Code for Power Query to return the result of the DATEDIFF function (difference between 2 dates)

How to use the FILTER function in Excel?

The FILTER function of Excel returns all the rows corresponding to a specific criteria. It's possible because of the Dynamic Arrays of Microsoft 365

Extract only the numbers of a cell in Excel

How to extract only the numbers from a string in a cell? Discover the formula and the logic to reach this result.

Moving Average in Excel

Moving average is the easiest way to analyse your data and estimate forecast. Build a moving average is very easy with Excel

Calculate Seniority in Excel

Calculate seniority is an easy task with Excel when you use the appropriate function.

VLOOKUP to the left in Excel

The function VLOOKUP is not able to return a value on the left of the search column. But you can do the job with XLOOKUP or INDEX MATCH

Create your custom functions with LAMBDA

The EXCEL LAMBDA function helps you to create your custom function without programmation.

Public holidays formulas

Formulas to calculate dynamic public holidays like Easter day, Thanksgiving.

Nested IF in Excel

How to write nested IF in Excel? There is 3 situations and 3 functions that can be used. All the case are explained here.

Search in a range of values with XLOOKUP

How to return a result in a range of values? With the XLOOKUP function, you can search in both direction, smaller or larger.

Change the default Date format in Excel

How to change the default Date format when you insert a date in a cell. The technique is explained in this article

Transform List to Double-entry Table

How to convert a list of data to a double-entry table? Only one function is needed to do the job. See the technique in this article

Function SUMIFS in Excel – Example

Discover how to use the SUMIFS function in Excel to filter and sum data based on multiple criteria in your worksheets

Create a Lookup Offset

When you have many times the same ID in your table, the following formula will help you to create a lookup offset.

Find Weekends or weekdays in Excel

Discover how you can easily find weekends or weekdays with Excel functions. No complex formulas are necessary.