Highlight the Date outside the deadline in Excel
How to highlight the dates outside the deadline in Excel? You must use the conditional formatting and create your own rule.
Date in Excel
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.
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, …. Formula to calculate the First Monday of the month The following formula returns the first Monday of the current month based on today's date. =TODAY()-DAY(TODAY())+8-WEEKDAY(TODAY()-DAY(TODAY())+7-1) Formula to calculate the last Monday […]
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
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.
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
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
Add Days Excluding the Weekend
How to add days to a date excluding the weekend? In Excel, one function exists to do the job without mistakes.
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.
1 2
