Add (subtract) months without exceeding the last day of the new month

by

The lubridate function %m+% may be useful here:

Add and subtract months to a date without exceeding the last day of the new month

as.Date("2014-12-31") %m+% months(6)
# [1] "2015-06-30"

To also handle the second case, you will need to round up to nearest month using ceiling_date, and subtract one day using days.

ceiling_date(as.Date("2014-02-28") %m+% months(6), unit = "month") - days(1)
# [1] "2014-08-31"

More Related Contents:

  1. Transform year/week to date object
  2. Convert date-time string to class Date
  3. How to convert Excel date format to proper date in R
  4. How to flatten / merge overlapping time periods
  5. Generate a sequence of the last day of the month over two years
  6. Is there a more elegant way to convert two-digit years to four-digit years with lubridate?
  7. Convert two-digit years to four-digit years with correct century
  8. Create a Vector of All Days Between Two Dates
  9. Axis labels on two lines with nested x variables (year below months)
  10. Get the difference between dates in terms of weeks, months, quarters, and years
  11. What are the “standard unambiguous date” formats for string-to-date conversion in R?
  12. How to change multiple Date formats in same column?
  13. How to get week numbers from dates?
  14. How to get a vertical geom_vline to an x-axis of class date?
  15. Add a month to a Date [duplicate]
  16. efficiently generate a random sample of times and dates between two dates
  17. How to subtract/add days from/to a date?
  18. Formatting dates with scale_x_date in ggplot2
  19. Convert a numeric month to a month abbreviation
  20. Convert string to date, format: “dd.mm.yyyy”
  21. How can I fix corrupted dates in R?
  22. Convert yyyymmdd string to Date class in R
  23. Efficient and accurate age calculation (in years, months, or weeks) in R given birth date and an arbitrary date
  24. Format date as Year/Quarter
  25. Converting a character string into a date in R
  26. Create end of the month date from a date variable
  27. Convert Factor to Date/Time in R
  28. Adding 15 business days in lubridate
  29. How to convert a date from a character string?
  30. change a column from birth date to age in r

Leave a Comment