The function DATE is very useful to create your custom dates. This article will explain you how the function works
How to split date and the time with Excel? With just to simple formulas, you can extract them in 2 different columns
How to convert the GPS coordinates (latitude- longitude) in degree, minute, seconde and also the other way round. The solution is the custom number format.
Discover how to customize easily your date format in Excel by changing the day, month or year. Many example.
How to add days to a date excluding the weekend? In Excel, one function exists to do the job without mistakes.
Discover how you can display time over 24 hours in your worksheets. You just have to customize the number format of your cells.
How to change the default Date format when you insert a date in a cell. The technique is explained in this article
How to convert Text Date to Numerical Date? For this Excel is the best tool to do the job, and there is two techniques.