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 …

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/