Tag Archive: MONTH

Articles sur le thème : MONTH

Difference between 2 dates – DATEDIF

Making a 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? Suppose that you have the following date 28/07/2017 05/08/2017 The result between …

Continue reading

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

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/

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/