The function DATE is very useful to create your custom dates. This article will explain you how the function works
Manipulate Date and Time is never easy but Excel can help you with formulas or specific techniques
The functions NOW & TODAY are very useful in Excel. It's the only way to build dynamic date to calculate gap between dates.
How to split date and the time with Excel? With just to simple formulas, you can extract them in 2 different columns
If you want to calculate the difference between 2 dates in Excel, you have to use a hidding function . It's the function DATEDIF.
Discover how to customize easily your date format in Excel by changing the day, month or year. Many example.
It's not easy to make calculation with time in Excel, especially if you want to do calculation for tenths, hundredths and thousandths.In this article, you will have all the explanations to do such calculation.
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
This article present how can create an automatic calendar in excel to avoid and refresh manually your worksheet, step by step. Tutorial video available.
Discover how you can easily find weekends or weekdays with Excel functions. No complex formulas are necessary.
Change the color of weekends in Excel with conditional formatting. Quick and easy with this step-by-step guide.
How to add days to a date excluding the weekend? In Excel, one function exists to do the job without mistakes.
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.
This step-by-step guide will explain to you how to build a birthday reminder in Excel with a specific color when the event occurs
Master time formatting in Excel. Learn how to display dates and times accurately, customize formats, and avoid common mistakes.
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