How to highlight the dates outside the deadline in Excel? You must use the conditional formatting and create your own rule.
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 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 […]
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 is an easy task with Excel when you use the appropriate function.
Formulas to calculate dynamic public holidays like Easter day, Thanksgiving.
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
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.
In Excel, you can change the color of the weekend in your workbook by creating your custom rule in the conditional formatting tool.
How to split date and the time with Excel? With just to simple formulas, you can extract them in 2 different columns
How to add days to a date excluding the weekend? In Excel, one function exists to do the job without mistakes.
If you want to calculate the difference between 2 dates in Excel, you have to use a hidding function . It's the function DATEDIF.