DATEDIF for POWER QUERY
This article gives you the M Code for Power Query to calculate the difference between 2 dates like the Excel function DATEDIF....
Category : Date
Manipulate Date and Time is never easy but Excel can help you with formulas or specific techniques
Calculate Seniority in Excel
Calculate seniority is an easy task with Excel when you use the appropriate function....
Public holidays formulas
Formulas to calculate dynamic public holidays like Easter day, Thanksgiving....
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...
Find Weekends or weekdays in Excel
Discover how you can easily find weekends or weekdays with Excel functions. No complex formulas are necessary....
NOW & TODAY
The functions NOW & TODAY are very useful in Excel. It's the only way to build dynamic date to calculate gap between dates....
First day – Last day in Excel
This article is a glossary of all the Excel functions to return the first day or the last day of the Month, the Quarter or...
Title with date in Excel
The TEXT function is very useful when you have to create a string which mixed text and number or date. You can customize each part...
Date Format in Excel
Discover how to customize easily your date format in Excel by changing the day, month or year. Many example....
Change the color of the weekends
Dates play a big role in many workbooks. With the tool conditional formatting you can create rules to highlight critical dates easily...