Get the next working day in PHP
By: Moshe
Here is an useful code snippet that calculates the next working day in the US. This takes into account the US Federal holiday as well.
<?php
function getNextWorkDayTime($date=null)
{
$time = is_string($date) ? strtotime($date) : (is_int($date) ? $date : time());
$y = date('Y', $time);
// calculate federal holidays
$holidays = array();
// month/day (jan 1st). iteration/wday/month (3rd monday in january)
$hdata = array('1/1'/*newyr*/, '7/4'/*jul4*/, '11/11'/*vet*/, '12/25'/*xmas*/, '3/1/1'/*mlk*/, '3/1/2'/*pres*/, '5/1/5'/*memo*/, '1/1/9'/*labor*/, '2/1/10'/*col*/, '4/4/11'/*thanks*/);
foreach ($hdata as $h1) {
$h = explode('/', $h1);
if (sizeof($h)==2) { // by date
$htime = mktime(0, 0, 0, $h[0], $h[1], $y); // time of holiday
$w = date('w', $htime); // get weekday of holiday
$htime += $w==0 ? 86400 : ($w==6 ? -86400 : 0); // if weekend, adjust
} else { // by weekday
$htime = mktime(0, 0, 0, $h[2], 1, $y); // get 1st day of month
$w = date('w', $htime); // weekday of first day of month
$d = 1+($h[1]-$w+7)%7; // get to the 1st weekday
for ($t=$htime, $i=1; $i<=$h[0]; $i++, $d+=7) { // iterate to nth weekday
$t = mktime(0, 0, 0, $h[2], $d, $y); // get next weekday
if (date('n', $t)>$h[2]) break; // check that it's still in the same month
$htime = $t; // valid
}
}
$holidays[] = $htime; // save the holiday
}
for ($i=0; $i<5; $i++, $time+=86400) { // 5 days should be enough to get to workday
if (in_array(date('w', $time), array(0, 6))) continue; // skip weekends
foreach ($holidays as $h) { // iterate through holidays
if ($time>=$h && $time<$h+86400) continue 2; // skip holidays
}
break; // found the workday
}
return $time;
}
?>
Archived Comments
Comment on this tutorial
- Data Science
- Android
- AJAX
- ASP.net
- C
- C++
- C#
- Cocoa
- Cloud Computing
- HTML5
- Java
- Javascript
- JSF
- JSP
- J2ME
- Java Beans
- EJB
- JDBC
- Linux
- Mac OS X
- iPhone
- MySQL
- Office 365
- Perl
- PHP
- Python
- Ruby
- VB.net
- Hibernate
- Struts
- SAP
- Trends
- Tech Reviews
- WebServices
- XML
- Certification
- Interview
categories
Related Tutorials
PHP code to write to a CSV file for Microsoft Applications
PHP code to write to a CSV file from MySQL query
PHP code to import from CSV file to MySQL
Password must include both numeric and alphabetic characters - Magento
Error: Length parameter must be greater than 0
PHP file upload prompts authentication for anonymous users
PHP file upload with IIS on windows XP/2000 etc
Multiple File Upload in PHP using IFRAME
Resume or Pause File Uploads in PHP
Exception in module wampmanager.exe at 000F15A0 in Windows 8