Number of months between two dates

by

I was about to say that’s simple, but difftime() stops at weeks. How odd.

So one possible answer would be to hack something up:

# turn a date into a 'monthnumber' relative to an origin
R> monnb <- function(d) { lt <- as.POSIXlt(as.Date(d, origin="1900-01-01")); \
                          lt$year*12 + lt$mon } 
# compute a month difference as a difference between two monnb's
R> mondf <- function(d1, d2) { monnb(d2) - monnb(d1) }
# take it for a spin
R> mondf(as.Date("2008-01-01"), Sys.Date())
[1] 24
R>

Seems about right. One could wrap this into some simple class structure. Or leave it as a hack 🙂

Edit: Also seems to work with your examples from the Mathworks:

R> mondf("2000-05-31", "2000-06-30")
[1] 1
R> mondf(c("2002-03-31", "2002-04-30", "2002-05-31"), "2002-06-30")
[1] 3 2 1
R>

Adding the EndOfMonth flag is left as an exercise to the reader 🙂

Edit 2: Maybe difftime leaves it out as there is no reliable way to express fractional difference which would be consistent with the difftime behavior for other units.

More Related Contents:

  1. How to prevent ifelse() from turning Date objects into numeric objects
  2. Convert date-time string to class Date
  3. How to convert Excel date format to proper date in R
  4. How to convert variable with mixed date formats to one format?
  5. Find the day of a week
  6. Specify custom Date format for colClasses argument in read.table/read.csv
  7. Converting year and month (“yyyy-mm” format) to a date?
  8. Changing date format in R
  9. Subset a dataframe between 2 dates
  10. Find which season a particular date belongs to
  11. as.Date with dates in format m/d/y in R
  12. Add a month to a Date [duplicate]
  13. efficiently generate a random sample of times and dates between two dates
  14. Convert integer to class Date
  15. as.Date returning NA while converting from ‘ddmmmyyyy’
  16. R: How to handle times without dates?
  17. Extract Month and Year From Date in R
  18. Extracting time from POSIXct
  19. Format for ordinal dates (day of month with suffixes -st, -nd, -rd, -th)
  20. How can I fix corrupted dates in R?
  21. How to sort a data frame by date
  22. Converting date in Year.decimal form in R
  23. How to subtract years?
  24. Subsetting a dataframe for a specified month and year
  25. R group by date, and summarize the values
  26. Convert integer as “20160119” to different columns of “day” “year” “month”
  27. Get date difference in years (floating point)
  28. set date range in ggplot
  29. Create a Vector of All Days Between Two Dates
  30. Using geom_rect for time series shading in R

Leave a Comment