Function DATE – YEAR – MONTH – DAY
The function DATE is very useful to create your custom dates. This article will explain you how the function works
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.
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
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.
Date Format in Excel
Discover how to customize easily your date format in Excel by changing the day, month or year. Many example.
Calculation of tenths, hundredths and thousandths with Excel
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.
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
How to make automatic calendar in Excel
This article present how can create an automatic calendar in excel to avoid and refresh manually your worksheet, step by step. Tutorial video available.
Find Weekend or Weekday in Excel
Discover how you can easily find weekends or weekdays with Excel functions. No complex formulas are necessary.
Change the Color of Weekends in Excel
Change the color of weekends in Excel with conditional formatting. Quick and easy with this step-by-step guide.
Add Days Excluding the Weekend in Excel
How to add days to a date excluding the weekend? In Excel, one function exists to do the job without mistakes.
How to Calculate the Week Number in Excel?
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.
How to Highlight a Birthday Reminder in Excel
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
Time Format in Excel to avoid mistakes
Master time formatting in Excel. Learn how to display dates and times accurately, customize formats, and avoid common mistakes.
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 the Year