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 format
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
Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde
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.
Date Format in Excel
Discover how to customize easily your date format in Excel by changing the day, month or year. Many example.
Add Days Excluding the Weekend
How to add days to a date excluding the weekend? In Excel, one function exists to do the job without mistakes.
How to display hours over 24 in Excel?
Discover how you can display time over 24 hours in your worksheets. You just have to customize the number format of your cells.
Change the default Date format in Excel
How to change the default Date format when you insert a date in a cell. The technique is explained in this article
Convert a Text Date to a Number Date
How to convert Text Date to Numerical Date? For this Excel is the best tool to do the job, and there is two techniques.