Tag Archive: Date format

Articles sur le thème : Date format

Function DATE – YEAR – MONTH – DAY

Formula to return the first day of the previous month

Discover how to manipulate dates in Excel with the function YEAR, MONTH and DAY in order to create dynamic dates with the function DATE

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 Coordinates Latitude and Longitude

Convert coordinates from degree minute second to Decimal

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 your 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/