How do I calculate the number of WORKING days from a given date

[matthewst]

I need to calculate 14 working days after a given date.
I found this on php.net:

<?php
$holidayList = array("04-03-2008","07-03-2008");
$j = $i = 1;
///changed to 14
while($i <= 5)
///it didn't work
{
    $day = strftime("%A",strtotime("+$j day"));
    $tmp = strftime("%d-%m-%Y",strtotime("+$j day"));
    if($day != "Sunday" and $day != "Saturday" and !in_array($tmp, $holidayList))
    {
        $i = $i + 1;
        $j = $j + 1;
    }
    else
        $j = $j + 1;
}
    $j = $j -1;
echo strftime("%A, %d-%m-%Y",strtotime("+$j day"));
?>

The author designed it to calculate 5 working days. When I change the 5 to 14 it calculates 22 working days.

[matthewst]

Does anyone know how to get it to go 14 days?
Lets say the given date is 3/1/2008.
It should calculate 3/20/2008.
Mine keeps going to 4/23/2008.

I'm using this to get the given date into the equation:

<?php
$holidayList = array("04-03-2008","07-03-2008");
$j = $i = 1;
///changed to 14
while($i <= 5)
///it didn't work
{
$day = $given_date;      

$day = strftime("%A",strtotime("+$j day"));
// then the rest of the code

[matthewst]

Getting closer.

$given_date = "3/1/2008";
$day = strftime("%A",strtotime("+$j $given_date"));

gets me 4/16/2008

Echoing $day = Friday
3/1/2008 was a Saturday

I changed the last bit of code to this.

$working_days = strftime("%A, %d-%m-%Y",strtotime("+$j day"));

Echoing $working_days = 04/16/2008

[Xager]

Easiest way is simply to use the time() function (if you don't need which day it is in letters):

<?php
$nextWeek = time() + (7 24 60 * 60);
// 7 days; 24 hours; 60 mins; 60secs
echo 'Now: '. date('Y-m-d') ."\n";
echo 'Next Week: '. date('Y-m-d', $nextWeek) ."\n";
// or using strtotime():
echo 'Next Week: '. date('Y-m-d', strtotime('+1 week')) ."\n";
?>

The above example will output something similar to:
Now: 2005-03-30
Next Week: 2005-04-06
Next Week: 2005-04-06

EDIT1: Oh, found out that if you change date('Y-m-d', $nextWeek) ."\n"; to date('Y-m-D', $nextWeek) ."\n"; you get a day as letters.

EDIT2: All you need really then is

echo 'Next Week: '. date('d/m/Y', strtotime('+2 week')) ."\n";

For DD/MM/YYYY

or

echo 'Next Week: '. date('D d/m/Y', strtotime('+2 week')) ."\n";

For Mon DD/MM/YYYY

[matthewst]

That would work but I have to account for weekends and holidays.

[Xager]

I tried that script and it works just fine for me, i changed 5 to 14 and today it showed "Tuesday, 22-04-2008" which is 14 days from now if you skip sundays and saturdays.

[Xager]

Are you sure that the script doesn't work for you if you change 5 to 14?

[matthewst]

<?php
$holidayList = array("04-03-2008","07-03-2008");
$j = $i = 0; //changed this to 0 or you were always starting one day ahead
$given_date = "3/1/2008";
$tmp1 = strtotime($given_date); //worked out a timstamp to start with
while($i < 14)
{
$tmp2 = strtotime("+$j day", $tmp1);
$day = strftime("%A",$tmp2);
echo strftime("%d-%m-%Y",$tmp2);

$tmp = strftime("%d-%m-%Y",$tmp2);
if(($day != "Sunday") && ($day != "Saturday" )&&(!in_array($tmp, $holidayList)))
{
    $i = $i + 1;
    $j = $j + 1;

}
else
{
    $j = $j + 1;

}
}
    $j = $j -1;
$newdate = strtotime("+$j day",$tmp1);
$working_days = strftime("%A, %d-%m-%Y",$newdate);
?>

Works perfectly!! Thanks!!