Tag Archive: MONTH

Articles sur le thème : MONTH

Difference between 2 dates – DATEDIF

Presentation Calculate the difference between 2 dates is not an easy task in Excel. You must take in consideration if you want to return a result based on the gap of the months or based of the years, or both. What is the problem? Let’s suppose that you have these 2 dates 28/07/2017 05/08/2017 The …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/difference-between-2-dates-datedif/

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/

First day – Last day in Excel

On this page, you will find some formulas to calculate specific days automatically. Building specific dates, such as the first or last day, is always a very complex task, in Excel or any other software. The function TODAY has been used in all the examples but you can replace it with your own date value. …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/first-day-last-day-in-excel/