Date function::counting days in a month that excludes saturdays and sundays

[codered27]

hi people

i need a function that takes in two dates and computes the difference between them but with a condition, exclude all saturdays and sundays within the specified period.

i was able to do a countdays function but the results are in calendar days, that is, it includes saturdays and sundays.

My idea is to loop through the start and end dates and put the results into an array variable. Within the loop i plan to put a condition like if(!$dayofweek == "Sun" || !$dayofweek=="Sat"), to prevent the array from getting the "Sat / Sun" days of the week and then use count function to sum up the array. Will this work? I appreciate any feedback from u guys. thanks a million.🙂

[LordShryku]

You're on the right track. An array wouldn't be necessary though. Could just strtotime and do the math. Something like this.

$date1 = '01/01/2007';
$date2 = '01/27/2007';

# Do some checks here for valid dates and to make sure date1 is less than date2

# Time strings
$time1 = strtotime($date1);
$time2 = strtotime($date2);

$days = 0;
while($time1 < $time2) {
   $chk = date('D', $time1); # Actual date conversion
   if($chk != 'Sat' && $chk != 'Sun')
      $days++;

   $time1 += 86400; # Add a day
}

echo $days.' days between '.$date1.' and '.$date2;

[Weedpacket]

I haven't done the detail, but it ought to be possible to do without the loop; after taking into account which day the period starts on, Saturday and Sunday are two days out of every seven. So for a 50-day period that starts on Tuesday, there are 4 days up to and including the following Friday, then there are (int)((50-4)/7)=6 full weeks of seven days, and then 4 more days, the first two of which are Saturday and Sunday. Total: 4+6*5+4-2 = 36.

[codered27]

Hey guys!

both ur suggestions work! thanks a million for helping out! Great!!!