Tag Archive: Date format

Articles sur le thème : Date format

Function DATE – YEAR – MONTH – DAY

Presentation of DAY, MONTH, YEAR The Functions YEAR, MONTH and DAY are very simple to understand. They extract each part of a date. DAY extracts the day of a date MONTH extracts the day of a date YEAR extracts the day of a date Individually, these functions do not interesting but used with the DATE function, they are …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/function-date-year-month-day/

Split Time and Date

If you have in a cell a time and a date (like the use of the function NOW) it’s easy to split them in 2 different cells. Split the date Let’s start from the following document where you have in column A data with date and time We want to split The date in column …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/split-time-and-date/

Add Days Excluding the Weekend

Common error when adding days When you build a schedule for your team, you ususally don’t include the weekend. So you can’t write a formula like this =B2+C2 Look at the first results! 🧐🧐🧐 Even if the first result looks correct, it isn’t. The result is Monday but it should be Wednesday. If you add …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/add-days-without-weekend/

Convert Latitude and Longitude

Nowadays, GPS localization is common. Some apps use decimal format (48.85833) while others return the coordinates in degrees, minutes and seconds (48°51’29.99”). In this article I will show you how to convert from one format to the other and vice-versa. Add GPS coordinates to address If you are looking to add GPS coordinates to an address, please …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/convert-latitude-longitude/

Date Format in Excel

What is a date in Excel? In Excel, you can display the same date in many different ways just by changing the date format. Dates are whole numbers Usually when you insert a date in a cell it is displayed in the format dd/mm/yyyy. Now if you change the cell’s format to Standard, the cell …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/date-format-in-excel/