11
With the new version of Microsoft Office, Excel has advanced features, including the calculation of the date difference.
Calculate date difference using the days function in Excel
Microsoft Excel is a comprehensive program that includes many features. To calculate the date difference between different days in Excel, you just need the appropriate command, which the system recognizes when entered correctly. Then add two more dates between which the program should determine the difference.
- First, enter the command =DATEDIF (abbreviation for DATEDIFFERENZ, which means days difference in German) in the desired Excel field. This is necessary so that the Excel program can calculate the difference between the dates.
- Then add the “target date” in brackets first, followed by the “source date”. The complete command then looks like this: =DATEDIF(“31.03.2013”;“21.03.2013”).
- If you already have a calendar in your Excel file, you can also use the field names instead of the dates. In this case, your command could look like this: =DATEDIF(A85,A75,“d”). The letter “d” in this context stands for “day”.
Have Excel calculate the difference of other units – this is how it is possible
You can not only have Excel differentiate between different dates. The program can also be used to determine different specifications for other parameters such as months or years. This makes Excel a versatile program for beginners and professionals alike.
- If you want to see the difference between months using Excel, use the abbreviation “m”. Your entry in the program is therefore =DATEDIF(A2,A3,“m”).
- If, on the other hand, you want to know the interval between years, Excel also has a suitable command for this. To do this, use the letter “y” (abbreviation of year in English). The formula is thus =DATEDIF(A2,A3,“y”).
- Of course, Excel can do a lot more, such as mathematical calculations or creating diagrams. This helps you with organization and planning at work and in your daily life, so you don’t lose track of various numbers.
