Date in Excel

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

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.

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 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.

You can easily convert date YYYYMMDD to DD/MM/YYYY in Excel with formulae or with the tool Table to Column in 3 step

How to calculate the public holidays in Excel? This article will present many formulae to calculate those dates according to the year.

Calculate seniority is an easy task with Excel when you use the appropriate function.

With Excel, you can build your dynamic date very easily. Discover how to build a dynamic date in this article.

Formula to calculate a date according to the week number. The result is not the same according to the iso week number system

All the formulas to calculate any day in a week, like the first Monday of the month, the last one, the next Tuesday, ...

1 2