EXCEL TIP – DATEDIF FUNCTION

Excel tips:

============

The syntax for DATEDIF:
=DATEDIF(DATE1,DATE2,INTERVAL)

This Excel function will calculate the intervals between DATE1 & DATE2. The Intervals can be defined in Excel which faciliates types of interval that you want to calculate. The definition of various intervals that can be used in Excel is as follows:

“d” – Days
“m” – Months
“y” – Years
“ym” – Months Excluding Years
“yd” – Days Excluding Years
“md” – Days excluding Years and Months

As an example, let us take two different dates and apply the above intervals to them as follows:

Date1 – 01 January 2010
Date2 – 31 August 2011

Based on above parameters, the results are displayed as follows:

=DATEDIF(DATE(2010,1,1),DATE(2011,8,31),”d”) will return 607 days.

=DATEDIF(DATE(2010,1,1),DATE(2011,8,31),”m”) will return 19 months.

=DATEDIF(DATE(2010,1,1),DATE(2011,8,31),”y”) will return 1 year.

=DATEDIF(DATE(2010,1,1),DATE(2011,8,31),”ym”) will return 7 months.

=DATEDIF(DATE(2010,1,1),DATE(2011,8,31),”yd”) will return 242 days.

=DATEDIF(DATE(2010,1,1),DATE(2011,8,31),”md”) will return 30 days.

With these tools, you can apply some of these principles to your business data in Microsoft Excel. This will gather useful data analytics on your records for evaluation and decision making.

Leave a Reply


*