With Excel, you can build your dynamic date very easily. Discover how to build a dynamic date in this article.
In this article, you will find all the formulas that allow you to calculate the days of the week; like the next Monday, Tuesday, Wednesday, …. Formula to calculate the First Monday of the month The […]
Formula to calculate a date according to the week number. The result is not the same according to the iso week number system
How to create a weekly calendar with just one formula. The SEQUENCE formula does the job and it’s not complex
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
This article gives you the M Code for Power Query to calculate the difference between 2 dates like the Excel function DATEDIF.
Calculate seniority is an easy task with Excel when you use the appropriate function.
Formulas to calculate dynamic public holidays like Easter day, Thanksgiving.
How to change the default Date format when you insert a date in a cell. The technique is explained in this article
Discover how you can easily find weekends or weekdays with Excel functions. No complex formulas are necessary.
The functions NOW & TODAY are very useful in Excel. It’s the only way to build dynamic date to calculate gap between dates.
You can easily convert date YYYYMMDD to DD/MM/YYYY in Excel with formulae or with the tool Table to Column in 3 step
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.
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
Discover how to customize easily your date format in Excel by changing the day, month or year. Many example.