Difference in months between two dates

by

Assuming the day of the month is irrelevant (i.e. the diff between 2011.1.1 and 2010.12.31 is 1), with date1 > date2 giving a positive value and date2 > date1 a negative value

((date1.Year - date2.Year) * 12) + date1.Month - date2.Month

Or, assuming you want an approximate number of ‘average months’ between the two dates, the following should work for all but very huge date differences.

date1.Subtract(date2).Days / (365.25 / 12)

Note, if you were to use the latter solution then your unit tests should state the widest date range which your application is designed to work with and validate the results of the calculation accordingly.

Update (with thanks to Gary)

If using the ‘average months’ method, a slightly more accurate number to use for the ‘average number of days per year’ is 365.2425.

More Related Contents:

  1. VB Net Class in C# [closed]
  2. What is a NullReferenceException, and how do I fix it?
  3. How to get ALL child controls of a Windows Forms form of a specific type (Button/Textbox)?
  4. How to write Unicode characters to the console?
  5. Get the correct week number of a given date
  6. Setting Objects to Null/Nothing after use in .NET
  7. Custom Compiler Warnings
  8. .NET Global exception handler in console application
  9. Is it possible to write to the console in colour in .NET?
  10. With block equivalent in C#?
  11. How do I get a human-readable file size in bytes abbreviation using .NET?
  12. Using statement vs. IDisposable.Dispose()
  13. Difference with Parameters.Add and Parameters.AddWithValue
  14. How to flatten nested objects with linq expression
  15. Getting day suffix when using DateTime.ToString()
  16. WebBrowser.DrawToBitmap() or other methods?
  17. Is String a primitive type?
  18. Difference between Lookup() and Dictionary(Of list())
  19. GC.Collect()
  20. Install to same path when upgrading application
  21. BinaryWriter Endian issue
  22. String.Format – how it works and how to implement custom formatstrings
  23. Is .NET 4.0 Compatible with Windows XP SP2 or below? [closed]
  24. How to get status code from webclient?
  25. How to check if the system audio is muted?
  26. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  27. How do I determine if a given date is the Nth weekday of the month?
  28. .NET Simulate Ctrl+Alt+Del Sendkeys
  29. List of exceptions that CAN’T be caught in .NET
  30. Detecting remote desktop connection

Leave a Comment