Converting a Date from YYYYMMDD to DD/MM/YYYY in Excel

Easily convert dates from the format YYYYMMDD to DD/MM/YYYY in Excel using this simple formula or the Text to Column tool.

Unlocking the Secrets of Excel’s DATE Function

Learn how to use the DATE function in Excel to effortlessly create dates from values, cell references, or calculations.

Displaying Days in Letters in Excel

This simple tip will improve readability and reduce errors in Excel: add the day of the week in letters to your dates.

Separate Date and Time with Power Query

This step-by-step guide will walk you through the process of split your date and time data with Power Query.

How to Calculate the Week Number in Excel?

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.

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.

Create a weekly calendar with just one formula in Excel

Unlock the potential of Excel by learning how to create a weekly calendar with just one formula. Step-by-step guide in this article.

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

How to Highlight a Birthday Reminder in Excel

This step-by-step guide will explain to you how to build a birthday reminder in Excel with a specific color when the event occurs

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