Tag Archive: TODAY

Articles sur le thème : TODAY

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/

NOW & TODAY

The functions TODAY and NOW are two extremely important functions. They allow you to create dynamic workbooks using the system date on your computer. We will use these functions to create workbooks such as Automatic calendar Worker timesheet Follow-up of supplier payments Delivery delays ... Presentation of the functions To view the current day, use …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/now-today/

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/