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 to do in Excel or with any software. 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 …

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/