Sponsored Link

Sponsored Link

Thursday, February 26, 2009

Datedif function

Datedif is function to find difference in dates. Days360 function also find the difference in days. But the major difference between Day360 and Datedif is Days360 consider 12 months each of 30 days hence its not very accurate. But, this is useful if you have an accounting system which require 12 months each of 30 days. Like in other post I will help you understand the syntax of formula followed by examples.

Formula: Datedif(PastDate, CurrentDate, "INTERVAL")

Interval: Interval can be days, Months, Years, Yearsdays, Yearmonths and monthdays. Mentioned below is description for each type of interval.

Past Date Current Date Interval Formula


24-Nov-03 10-May-08 days        =DATEDIF(A2,B2,"d")


24-Nov-03 10-May-08 months        =DATEDIF(A3,B3,"m")


24-Nov-03 10-May-08 years        =DATEDIF(A4,B4,"y")


24-Nov-03 10-May-08 yeardays    =DATEDIF(A5,B5,"yd")


24-Nov-03 10-May-08 yearmonths =DATEDIF(A6,B6,"ym")


24-Nov-03 10-May-08 monthdays  =DATEDIF(A7,B7,"md")


Copy-Paste the table in MS Excel starting from A1 Cell.

I have attempted to give example in another post. I am enclosing the link below. Request you to visit same.

Datedif example

Kindly post your view about post in comments. Also, you can Subscribe to Free MS Excel help by Email to receive latest update about this blog and we will also send free add-ins, e-books and lot right in your inbox.

We assure you knowledge, not SPAM!


Post a Comment