How to find week date ranges for a given month

Question

I need to display a range of dates in corresponding week for selected month. Suppose the selected values are $month=2 and $year=2017. The output should show a list of ranged dates for weeks in that particular month selected.

$month = $_GET['month'];
$year = $_GET['year'];
 ...

Output:
Week 1: 01/02/2017 - 05/02/2017
Week 2: 06/02/2017 - 12/02/2017
Week 3: 13/02/2017 - 19/02/2017
Week 4: 20/02/2017 - 26/02/2017
Week 5: 27/02/2017 - 28/02/2017

Ive look through Split the current month in to weeks in php , Get week number in month from date in PHP? and Split date ranges into corresponding weeks , but none of them working for me.

Thanks.

Andreas · Accepted Answer · 2017-12-08T05:22:48.390

Here is one method that loops with strtotime.

I add 86400*7 on Unix to add a week.

$month = 2;
$year = 2017;

$week = date("W", strtotime($year . "-" . $month ."-01")); // weeknumber of first day of month

Echo date("d/m/Y", strtotime($year . "-" . $month ."-01")) ." - "; // first day of month
$unix = strtotime($year."W".$week ."+1 week");
While(date("m", $unix) == $month){ // keep looping/output of while it's correct month

   Echo date("d/m/Y", $unix-86400) . "\n"; // Sunday of previous week
   Echo date("d/m/Y", $unix) ." - "; // this week's monday
   $unix = $unix + (86400*7);
}
Echo date("d/m/Y", strtotime("last day of ".$year . "-" . $month)); //echo last day of month

https://3v4l.org/LAMBl

thank you! this really help me alot.. yours was intelligible.. i owe u big time :) — Lynn, Dec 08 '17 at 07:07

GYaN · Answer 2 · 2017-12-08T04:48:47.673

Here is your solution

$month = $_GET['month'];
if($month<10)$month = '0'.$month;
$year = $_GET['year'];
$days = cal_days_in_month(CAL_GREGORIAN,$month,$year);
$start = 1; $end = 5;
function get_week_array($start,$end){
    global $month, $year,$days;
    for($i=0;$i<$end;$i++){
        if($start<10)$array[] = '0'.$start.'/'.$month.'/'.$year;
        else $array[] = $start.'/'.$month.'/'.$year;
        $start = $start+1;
        if($start==$days+1)break;
    }
    return $array;
}
$total = 0;
while($days>$total){
    $week[] = get_week_array($start,$end);
    $total = $total+$end;
    $start = $total+1;
    $end = 7;
}
echo "<pre>";print_r($week);

Output

Array
(
    [0] => Array
        (
            [0] => 01/02/2017
            [1] => 02/02/2017
            [2] => 03/02/2017
            [3] => 04/02/2017
            [4] => 05/02/2017
        )

    [1] => Array
        (
            [0] => 06/02/2017
            [1] => 07/02/2017
            [2] => 08/02/2017
            [3] => 09/02/2017
            [4] => 10/02/2017
            [5] => 11/02/2017
            [6] => 12/02/2017
        )

    [2] => Array
        (
            [0] => 13/02/2017
            [1] => 14/02/2017
            [2] => 15/02/2017
            [3] => 16/02/2017
            [4] => 17/02/2017
            [5] => 18/02/2017
            [6] => 19/02/2017
        )

    [3] => Array
        (
            [0] => 20/02/2017
            [1] => 21/02/2017
            [2] => 22/02/2017
            [3] => 23/02/2017
            [4] => 24/02/2017
            [5] => 25/02/2017
            [6] => 26/02/2017
        )

    [4] => Array
        (
            [0] => 27/02/2017
            [1] => 28/02/2017
        )

)

@Lynn min and max of each subarray. But usually an answer should have comments an explanation of what the code does and how to use it. — Andreas, Dec 08 '17 at 07:54

score 0 · Answer 3 · answered Dec 08 '17 at 05:10

Try this:

<?php

$month = 12;
$year = 2017;

$date = new DateTime($year.'-'.$month.'-01');

$count = 1;
$week[$count]['start'] =  $date->format('Y-m-d');

while (1) {
    $date->modify('+1 day');
    if ($date->format('m') != $month) {
        $week[$count]['end'] = $date->format('Y-m-d');
        break;
    }

    if ($date->format('D') === 'Sun') {
        $week[$count++]['end'] = $date->format('Y-m-d');
    }

    if ($date->format('D') === 'Mon') {
        $week[$count]['start'] = $date->format('Y-m-d');
    }

}


print_r($week);

score 0 · Answer 4 · answered Dec 08 '17 at 06:56

This method can show weeks including day of week to break that week

Show test

$month = '2';
$year = '2017';
$lastDayOfWeek = '7'; //1 (for monday) to 7 (for sunday)

function getWeeksInMonth($year, $month, $lastDayOfWeek)
{
    $aWeeksOfMonth = [];
    $date = new DateTime("{$year}-{$month}-01");
    $iDaysInMonth = cal_days_in_month(CAL_GREGORIAN, $month, $year);
    $aOneWeek = [$date->format('Y-m-d')];
    $weekNumber = 1;
    for ($i = 1; $i <= $iDaysInMonth; $i++)
    {
        if ($lastDayOfWeek == $date->format('N') || $i == $iDaysInMonth)
        {
            $aOneWeek[]      = $date->format('Y-m-d');
            $aWeeksOfMonth[$weekNumber++] = $aOneWeek;
            $date->add(new DateInterval('P1D'));
            $aOneWeek = [$date->format('Y-m-d')];
            $i++;

        }
        $date->add(new DateInterval('P1D'));
    }
    return $aWeeksOfMonth;
}

$weeks = getWeeksInMonth($year, $month, $lastDayOfWeek);

foreach($weeks as $weekNumber => $week){
    echo "Week {$weekNumber}: {$week[0]} - {$week[1]}\r\n";
}

Output

Week 1: 2017/02/01 - 2017/02/05
Week 2: 2017/02/06 - 2017/02/12
Week 3: 2017/02/13 - 2017/02/19
Week 4: 2017/02/20 - 2017/02/26
Week 5: 2017/02/27 - 2017/02/28

How to find week date ranges for a given month

4 Answers4

Output