DateDiff returns the interval of time between two dates: : DateDiff « Date Functions « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Date Functions
  3. DateDiff

DateDiff returns the interval of time between two dates:

 
Sub DateDiffExample()
  Debug.Print DateDiff("d", Now, "12/31/2010")
  ''Days until 12/31/2010
  Debug.Print DateDiff("m", Now, "12/31/2010")
  ''Months until 12/31/2010
  Debug.Print DateDiff("yyyy", Now, "12/31/2010")
  ''Years until 12/31/2010
  Debug.Print DateDiff("q", Now, "12/31/2010")
  ''Quarters until 12/31/2010
End Sub








Related examples in the same category

1.DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]]) returns the interval between two specified dates
2.Difference between two dates in days and months:
3.returns the number of weeks between June 3, 2006 and September 30, 2006:
4.DateDiff() function returns the difference between two dates. The unit for the difference is specified as a string ( "s" for second, "m" for month, "yyyy" for year, and so on).
5.DateDiff("m", Now, "10/10/03")
6.DateDiff("yyyy", Now, "10/10/03")
7.DateDiff("m", "3/15/2000", Now)
8.Use DateDiff function