Dan
Dan

Reputation: 6553

PHP - Get dates of next 5 weekdays?

I'm trying to create an array of the next 5 working week days (Monday - Friday, excluding today). I know the working week varies around the world but this is not important for what I am trying to do.

So, for example, if today is a Wednesday, I want the dates for Thursday and Friday of the current week and Monday, Tuesday and Wednesday of the following week.

I thought this would work:

$dates = array();

for ($i = 1; $ < 6; $i ++)
{
    $dates[] = date('Y-m-d', strtotime('+ '.$i.' weekday'));
}

But for today, it is giving me:

Any advice appreciated.

Thanks

Upvotes: 1

Views: 4108

Answers (4)

Expedito
Expedito

Reputation: 7795

You can do like this:

$now = time();
$day = 60*60*24;
$days = array();
for ($i=1; $i<=7; $i++){
    $ts = $now + $day*$i;
    if (date("N", $ts) < 6){
        $days[] = date("l jS", $ts);
    }
}

The output for the above code is:

Array(
    [0] => Monday 1st
    [1] => Tuesday 2nd
    [2] => Wednesday 3rd
    [3] => Thursday 4th
    [4] => Friday 5th
)

Upvotes: 0

womplefrog
womplefrog

Reputation: 799

function getWeekdayDatesFrom($format, $start_date_epoch, $end_date_epoch, $range) {

    $dates_arr = array();

    if( ! $range) {
        $range = round(abs($start_date_epoch-$end_date_epoch)/86400) + 1;
    } else {
        $range = $range + 1; //end date inclusive
    }

    $current_date_epoch = $start_date_epoch;

    for($i = 1; $i <= $range; $i+1) {

        $d = date('N',  $current_date_epoch);

        if($d <= 5) { // not sat or sun
            $dates_arr[] = "'".date($format, $current_date_epoch)."'";
        }

        $next_day_epoch = strtotime('+'.$i.'day', $start_date_epoch);
        $i++;
        $current_date_epoch = $next_day_epoch;

    }

    return $dates_arr;
} 

Upvotes: 1

tobia.zanarella
tobia.zanarella

Reputation: 1266

This should work:

$dates = array();
$i = 0;

while(true) {
    $i++;

    $time = strtotime("+$i days");
    $dayOfWeek = date('w', $time);

    /* 'w' - day of week, numeric, i.e. "0" (Sunday) to "6" (Saturday) */
    if( ($dayOfWeek == 0) or ($dayOfWeek == 6) ) {
        continue;
    }

    $dates[] = date('Y-m-d', $time);

    if( count($dates) >= 5 ) {
        break;
    }
}

Upvotes: 0

Alessandro
Alessandro

Reputation: 1453

Try this

$dates = array();
$date = new DateTime();

while (count($dates)<5)
{
    $date->add(new DateInterval('P1D'));
    if ($date->format('N')<6)
        $dates[]=$date->format('Y-m-d');
}

Upvotes: 8

Related Questions