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

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)

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.

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.

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 of your date

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 in Excel

In Excel, you can change the color of the weekend in your workbook by creating your custom rule in the conditional formatting tool.

Excel Split Date and Time

How to split date and the time with Excel? With just to simple formulas, you can extract them in 2 different columns