[Resolved] Calculate Weekdays

mark_and_co

Hi Guys,

I've just developed a function for a website that sets a delivery date as x working days (Mon-Fri) from the invoice date.

function workingdays($gap) {
$today = date("w");
for ($i=0;$i<$gap;$i++) {
$today++;
if (($today==6)||($today==0)) {$today=1;}
} 
return $today;
}

This will return 1 for Monday and 5 for Friday etc.

Use $gap to set how many days extra you want.
For example if today is Monday and delivery is set for Friday use workingdays(4). This is fine for what I want it to do, but is fairly limited to what can be done. Such as if you want the $gap to be 9 how do you get that tranferred to a date?

I appreciate your help

LordShryku

Just slopped this together. Should work, but I haven't tested it. Returns in the YYYY-MM-DD format.

function workingdays($gap) {
   if(is_numeric($gap)) { //needs to be a number
      for($i=0;$i<=$gap;$i++) {
         $newday = date("w",strtotime("+".$i." days")); // increment day of week
         if($newday == 0 || $newday == 6) { // if sat. or sun.
            $gap++; // increment gap
         }
         if($i == $gap) { // we've hit the number
            return date("Y-m-d",strtotime("+".$gap." days"));
         }
      }
   }
   return false;
}

So today's Thursday, 2004-01-29, using

echo workingdays(4);

should return 2004-02-04.

mark_and_co

Hi,

Thanks - that worked perfect - I would never had thought to do it that way!!

Thanks once again
You're a star 😃

Mark