Weekends or weekdays in Excel
Separating weekends and weekdays is a basic job in Excel. For example, when you have to build an automatic calendar. The function WEEKDAY Presentation This...
Category : Date
Manipulate Date and Time is never easy but Excel can help you with formulas or specific techniques
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....
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...
Change the color of the weekends
Dates play a big role in many workbooks. With the tool conditional formatting you can create rules to highlight critical dates easily...
Split Date and Time
Two techniques to extract the date and the time. By Formulas or with Power Query...
Weekly calendar 2020 in one formula
Discover how to create a weekly calendar and with just one formula.With the new dynamic array, it's very easy to do with the function SEQUENCE...
Difference between 2 dates – DATEDIF
If you want to calculate the difference between 2 dates in Excel, you have to use a hidding function . It's the function DATEDIF....
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....
Convert YYYYMMDD to DD/MM/YYYY
You can transform your dates in format YYYYMMDD to DD/MM/YYYY without any formula....
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...