Tag Archive: DATEDIF

Articles sur le thème : DATEDIF

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/

How to Highlight a Birthday Automatically

In this article, you will see how you can change color when a Birthday is coming up without using a macro. Step 1: Add today’s date First of all, add the current date in a new column using the function TODAY(). =TODAY() Step 2: Months until birthday In a new column, calculate the number of …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/how-to-highlight-birthday-automatically/