Formulas for calculating the days of the week
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, …....
Category : Date
Manipulate Date and Time is never easy but Excel can help you with formulas or specific techniques
Calculate a date from the week number
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 build your custom date in Excel
With Excel you can build your custom date very easily. Discover how to manipulate the three components of a date....
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....
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...