Day difference without weekends

by

Very easy with my favourites: DateTime, DateInterval and DatePeriod

$start = new DateTime('2012-09-06');
$end = new DateTime('2012-09-11');
// otherwise the  end date is excluded (bug?)
$end->modify('+1 day');

$interval = $end->diff($start);

// total days
$days = $interval->days;

// create an iterateable period of date (P1D equates to 1 day)
$period = new DatePeriod($start, new DateInterval('P1D'), $end);

// best stored as array, so you can add more than one
$holidays = array('2012-09-07');

foreach($period as $dt) {
    $curr = $dt->format('D');

    // substract if Saturday or Sunday
    if ($curr == 'Sat' || $curr == 'Sun') {
        $days--;
    }

    // (optional) for the updated question
    elseif (in_array($dt->format('Y-m-d'), $holidays)) {
        $days--;
    }
}


echo $days; // 4

More Related Contents:

  1. Count array by parse value of array
  2. CodeIgniter – foreach loop
  3. How to use query string in Codeigniter?
  4. Days remaining before birthday in php [duplicate]
  5. How to get time difference in minutes in PHP
  6. How can I compare two dates in PHP?
  7. How should I choose an authentication library for CodeIgniter? [closed]
  8. base_url() function not working in codeigniter
  9. How to load a controller from another controller in codeigniter?
  10. Codeigniter displays a blank page instead of error messages
  11. Accessing dates in PHP beyond 2038
  12. Date Difference in php on days? [duplicate]
  13. How to list all months between two dates
  14. Difference between 2 dates in seconds [duplicate]
  15. How to call codeigniter controller function from view
  16. Print time in 15-minute increments between two times in the same day
  17. passing php variable from controller to javascript function in the head of a view
  18. How to reformat date in PHP?
  19. Set timezone in PHP and MySQL
  20. PHP date() in foreign languages – e.g. Mar 25 Aoû 09 [duplicate]
  21. How to set cron job URL for CodeIgniter?
  22. Codeigniter echoing [::1] instead of localhost
  23. PHP date returning wrong Month on subtracting one month
  24. Get date range between two dates excluding weekends
  25. Advantages / Disadvantages of pconnect option in CodeIgniter
  26. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  27. PHP day of week numeric to day of week text
  28. How to stop GD2 from washing away the colors upon resizing images?
  29. How can I have CodeIgniter load specific pages using SSL?
  30. Validate date format in php

Leave a Comment