{"id":2166,"date":"2021-04-04T12:21:30","date_gmt":"2021-04-04T12:21:30","guid":{"rendered":"http:\/\/marstraining.in\/?p=2166"},"modified":"2021-04-04T13:27:36","modified_gmt":"2021-04-04T13:27:36","slug":"how-to-calculate-difference-between-two-date-in-excel-datedif","status":"publish","type":"post","link":"https:\/\/marstraining.in\/?p=2166","title":{"rendered":"How To Calculate Difference Between Two Dates in Excel (DATEDIF)???"},"content":{"rendered":"

MS Excel DATEDIF function returns the difference between two date values, based on the given interval.<\/p>\n

The DATEDIF<\/strong> function is a hidden built-in function in Excel that is categorized as a\u00a0Date\/Time Function<\/em><\/strong>. It can be used as other worksheet function of Excel, but user can\u2019t get help of this function due to its hidden characteristics.<\/p>\n

Note<\/strong>–<\/strong>DATEDIF<\/strong>\u00a0is not a standard\u00a0function<\/strong>\u00a0and hence not a part of\u00a0Excel functions<\/strong>\u00a0library and so there is no documentation(help) for this. Excel<\/strong>\u00a0provides the\u00a0DATEDIF function<\/strong>\u00a0in order to support older workbooks from Lotus 1-2-3. The\u00a0DATEDIF function<\/strong>\u00a0may calculate wrong results under certain scenarios.<\/p>\n

Syntax<\/strong><\/p>\n

Following is syntax of\u00a0 the DATEDIF function:<\/p>\n

DATEDIF( start_date, end_date, interval )<\/span><\/p>\n

Parameters\/Arguments<\/u><\/strong><\/p>\n

start_date and end_date- <\/strong>The two dates to calculate the difference between where the start_date can\u2019t be greater than end_date. The Entered Date format<\/strong> should also match with your computer Date format,i.e. if your computer Date format is MM\/DD\/YYYY then you can\u2019t type DD\/MM\/YYYY<\/p>\n

Interval- <\/strong>The interval of time to use to calculate the difference between date1 and date2 is known as INTERVAL<\/strong> here. Below is a list of valid interval that can be used<\/p>\n

 <\/p>\n\n\n\n\n\n\n\n\n\n\n
Interval<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n<\/thead>\n
Y<\/strong><\/td>\nThe number of complete years.<\/strong><\/td>\n<\/tr>\n
M<\/strong><\/td>\nThe number of complete months.<\/strong><\/td>\n<\/tr>\n
D<\/strong><\/td>\nThe number of days.<\/strong><\/td>\n<\/tr>\n
MD<\/strong><\/td>\nThe difference between the days (months and years are ignored).<\/strong><\/td>\n<\/tr>\n
YM<\/strong><\/td>\nThe difference between the months (days and years are ignored).<\/strong><\/td>\n<\/tr>\n
YD<\/strong><\/td>\nThe difference between the days (years and dates are ignored).<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n


\nReturns
\n<\/strong>The DATEDIF function returns a numeric value as a result.<\/p>\n

Applies to version<\/strong><\/p>\n