how to find number of mondays or tuesdays between two dates?

by

The answer by w35I3y was almost correct, but I was getting errors using that function. This function correctly calculates the number of Mondays or any specific day between two given dates:

/** 
* Counts the number occurrences of a certain day of the week between a start and end date
* The $start and $end variables must be in UTC format or you will get the wrong number 
* of days  when crossing daylight savings time
* @param - $day - the day of the week such as "Monday", "Tuesday"...
* @param - $start - a UTC timestamp representing the start date
* @param - $end - a UTC timestamp representing the end date
* @return Number of occurences of $day between $start and $end
*/
function countDays($day, $start, $end)
{        
    //get the day of the week for start and end dates (0-6)
    $w = array(date('w', $start), date('w', $end));

    //get partial week day count
    if ($w[0] < $w[1])
    {            
        $partialWeekCount = ($day >= $w[0] && $day <= $w[1]);
    }else if ($w[0] == $w[1])
    {
        $partialWeekCount = $w[0] == $day;
    }else
    {
        $partialWeekCount = ($day >= $w[0] || $day <= $w[1]);
    }

    //first count the number of complete weeks, then add 1 if $day falls in a partial week.
    return floor( ( $end-$start )/60/60/24/7) + $partialWeekCount;
}

Example Usage:

$start = strtotime("tuesday UTC");    
$end = strtotime("3 tuesday UTC");       
echo date("m/d/Y", $start). " - ".date("m/d/Y", $end). " has ". countDays(0, $start, $end). " Sundays";

Outputs something like:
09/28/2010 – 10/19/2010 has 3 Sundays.

More Related Contents:

  1. Week of the day for current date in php [closed]
  2. Convert a date format in PHP [duplicate]
  3. Correctly determine if date string is a valid date in that format
  4. Checking if date is weekend PHP
  5. PHP check if date between two dates
  6. PHP compare time
  7. Adding one day to a date
  8. Add ‘x’ number of hours to date
  9. How can I find the first and last date in a month using PHP?
  10. Simplest way to increment a date in PHP?
  11. How to count days between two dates in PHP?
  12. PHP get start and end date of a week by weeknumber
  13. Select entries between dates in doctrine 2
  14. PHP date() and strtotime() return wrong months on 31st
  15. How to get previous month and year relative to today, using strtotime and date?
  16. How to convert ISO8601 to Date format in php
  17. How to calculate time difference in PHP? [duplicate]
  18. How do I find the hour difference between two dates in PHP?
  19. Date function output in a local language [duplicate]
  20. PHP date – get name of the months in local language
  21. Get most recent date from an array of dates in “Y-m-d H:i:s” format
  22. How do you explain the result for a new \DateTime(‘0000-00-00 00:00:00’)?
  23. Increase days to php current Date()
  24. Convert to date format dd/mm/yyyy
  25. PHP: add seconds to a date
  26. PHP: How to check if a date is today, yesterday or tomorrow
  27. Get a PHP DateTime difference in days, considering midnight as a day change
  28. Next business day of given date in PHP
  29. What is the MM/DD/YYYY regular expression and how do I use it in php?
  30. Get date for monday and friday for the current week (PHP)

Leave a Comment