Power Query Split Date and Time
This step-by-step guide will walk you through the process of split your date and time data with Power Query.
DATE
How to build your dynamic dates in Excel
With Excel, you can build your dynamic date very easily. Discover how to build a dynamic date in this article.
Calculate any day of the week with formula
All formulas that allow you to calculate the following or previous days such as Monday, Tuesday, Wednesday, ...
Create a weekly calendar with just one formula
How to create a weekly calendar with just one formula. The SEQUENCE formula does the job and it's not complex
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 the Year
Convert YYYYMMDD to DD/MM/YYYY
You can easily convert date YYYYMMDD to DD/MM/YYYY in Excel with formulae or with the tool Table to Column in 3 step
The Correct Value for a Week Number
In Excel the way to return the week number is based on the American system. But most of countries use the ISO system. What is the technique to avoid mistakes.
Change the color of holidays
You can change automatically the color of the public holidays in your calendar with the conditional formating and a custom rule.
Function DATE – YEAR – MONTH – DAY
The function DATE is very useful to create your custom dates. This article will explain you how the function works
How to Highlight a Birthday Automatically
In this article, you will see how you can change color when a Birthday is coming up without using a macro.
