Excel Public holidays formulas
How to calculate the public holidays in Excel? This article will present many formulae to calculate those dates according to the year.
Custom function
Create your custom functions with LAMBDA
The new LAMBDA function helps you to create your custom Excel function without programmation. Let's see how it works.
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)