Calculate the number of weekdays between 2 dates in R

by 
Date1 <- as.Date("2011-01-30")
Date2 <- as.Date("2011-02-04")    
sum(!weekdays(seq(Date1, Date2, "days")) %in% c("Saturday", "Sunday"))

EDIT: And Zach said, let there be Vectorize 🙂

Dates1 <- as.Date("2011-01-30") + rep(0, 10)
Dates2 <- as.Date("2011-02-04") + seq(0, 9)
Nweekdays <- Vectorize(function(a, b) 
  sum(!weekdays(seq(a, b, "days")) %in% c("Saturday", "Sunday")))
Nweekdays(Dates1, Dates2)

More Related Contents:

  1. Aggregate Daily Data to Month/Year intervals
  2. Aggregating hourly data into daily aggregates
  3. Determine Whether Two Date Ranges Overlap
  4. How to prevent ifelse() from turning Date objects into numeric objects
  5. How do I convert a date/time string to a DateTime object in Dart?
  6. How to convert Excel date format to proper date in R
  7. Split date-time column into Date and time variables
  8. Change timezone in a POSIXct object
  9. How to parse milliseconds?
  10. How do you convert POSIX date to day of year?
  11. What’s the difference between ISO 8601 and RFC 3339 Date Formats?
  12. How do you specify the date format used when JAXB marshals xsd:dateTime?
  13. Convert 12-hour date/time to 24-hour date/time
  14. Convert UTC string to time object
  15. Date conversion from POSIXct to Date in R
  16. converting datetime string to POSIXct date/time format in R
  17. Parsing of Ordered Timestamps in Local Time (to UTC) While Observing Daylight Saving Time
  18. What is the difference between UTC and GMT?
  19. How to Parse Year + Week Number in R?
  20. R – converting date and time fields to POSIXct with HHMMSS format
  21. How to determine if date is a weekend or not (not using lubridate)
  22. Best practices with saving datetime & timezone info in database when data is dependant on datetime
  23. How precise is the internal clock of a modern PC?
  24. Convert hours:minutes:seconds to minutes
  25. R: merge two irregular time series
  26. Calculating Time Difference between two columns
  27. Find all date ranges for overlapping start and end dates in R
  28. Twig date difference
  29. Convert decimal day to HH:MM
  30. Round a POSIX date (POSIXct) with base R functionality

Leave a Comment