Calculate business days

Question

I need a method for adding  business days  in PHP  For example  Friday 12 5   3 business days   Wednesday 12 10   At a minimum I need the code to understand weekends  but ideally it should account for US federal holidays as well  I m sure I could come up with a solution by brute force if necessary  but I m hoping there s a more elegant approach out there  Anyone   Thanks

User · Answer

The add business days has a small bug  Try the following with the existing function and the output will be a Saturday   Startdate   Friday Business days to add   1 Holidays array   Add date for the following Monday   I have fixed that in my function below   function add business days  startdate   buisnessdays   holidays   array     dateformat    Y-m-d     i  1   dayx  strtotime  startdate    buisnessdays  ceil  buisnessdays    while  i  lt   buisnessdays         day  date  N   dayx         date  date  Y-m-d   dayx       if  day  lt  6  amp  amp   in array  date  holidays            i          dayx  strtotime  date    1 day          If the calculated day falls on a weekend or is a holiday  then add days to the next business day  day  date  N   dayx    date  date  Y-m-d   dayx    while  day  gt   6    in array  date  holidays          dayx  strtotime  date    1 day         day  date  N   dayx        date  date  Y-m-d   dayx      return date  dateformat   dayx

User · Answer

PHPClasses have a nice class for this named PHP Working Days  You can check this class

User · Answer

Get the number of working days without holidays between two dates    Use example   echo number of working days  2013-12-23    2013-12-29      Output   3   Function   function number of working days  from   to         workingDays    1  2  3  4  5     date format   N  1   Monday            holidayDays      -12-25     -01-01    2013-12-23      variable and fixed holidays       from   new DateTime  from        to   new DateTime  to        to- gt modify   1 day         interval   new DateInterval  P1D         periods   new DatePeriod  from   interval   to         days   0      foreach   periods as  period            if   in array  period- gt format  N     workingDays   continue          if  in array  period- gt format  Y-m-d     holidayDays   continue          if  in array  period- gt format   -m-d     holidayDays   continue           days              return  days

User · Answer

I just created this function  which seems to work very well   function getBusinessDays  date1   date2        if  is numeric  date1             date1   strtotime  date1              if  is numeric  date2             date2   strtotime  date2              if  date2  lt   date1            temp date    date1           date1    date2           date2    temp date          unset  temp date               diff    date2 -  date1        days diff   intval  diff    3600   24         current day of week   intval date  N    date1         business days   0       for  i   1   i  lt    days diff   i             if  in array  current day of week  array  Sunday    gt  1   Saturday    gt  7                  business days                        current day of week            if  current day of week  gt  7                current day of week   1                       return  business days     echo  Business days      getBusinessDays  8 15 2014    8 8 2014

User · Answer

Although this question has over 35 answers at the time of writing  there is a better solution to this problem   flamingLogos provided an answer which is based on Mathematics and doesn t contain any loops  That solution provides a time complexity of T 1   However  the math behind it is pretty complex especially the leap year handling   Glavic provided a good solution that is minimal and elegant  But it doesn t preform the calculation in a constant time  so it could produce a denial of service  DOS  attack or at least timeout if used with large periods like 10 or 100 of years since it loops on 1 day interval  So I propose a mathematical approach that have constant time and yet very readable  The idea is to count how many days to have complete weeks   lt  php function getWorkingHours  start date   end date           validate input     if  validateDate  start date      validateDate  end date   return   error    gt   Invalid Date        if  end date  lt   start date  return   error    gt   End date must be greater than or equal Start date           We save timezone and switch to UTC to prevent issues      old timezone   date default timezone get        date default timezone set  quot UTC quot          startDate   strtotime  start date        endDate   strtotime  end date          The total number of days between the two dates  We compute the no  of seconds and divide it to 60 60 24       We add one to include both dates in the interval       days     endDate -  startDate    86400   1       no full weeks   ceil  days   7         we get only missing days count to complete full weeks       we take modulo 7 in case it was already full weeks      no of missing days    7 -   days   7     7        workingDays    no full weeks   5        Next we remove the working days we added  this loop will have max of 6 iterations      for   i   1   i  lt    no of missing days   i             if date  N    endDate    i   86400   lt  6   workingDays--              holidays   getHolidays date  Y    startDate   date  Y    endDate           We subtract the holidays     foreach  holidays as  holiday            time stamp strtotime  holiday             If the holiday doesn t fall in weekend         if   startDate  lt    time stamp  amp  amp   time stamp  lt    endDate  amp  amp  date  quot N quot   time stamp     6  amp  amp  date  quot N quot   time stamp     7               workingDays--             date default timezone set  old timezone       return   days    gt   workingDays       The input to the function are in the format of Y-m-d in php or yyyy-mm-dd in general date format  The get holiday function will return an array of holiday dates starting from start year and until end year

User · Answer

I had this same need i started with bobbin s first example and ended up with this    function add business days  startdate  buisnessdays  holidays array    dateformat        enddate   strtotime  startdate        day   date  N   enddate       while  buisnessdays  gt  1            enddate   strtotime date  Y-m-d   enddate     1 day             day   date  N   enddate           if  day  lt  6  amp  amp   in array  enddate  holidays   buisnessdays--            return date  dateformat  enddate         hth someone

User · Answer

date default timezone set  America New York          Given a number days out  what day is that when counting by  business  days     get the next business day  by default it looks for next business day     ie calling   date   get next busines day    on monday will return tuesday                  date   get next busines day 2   on monday will return wednesday                  date   get next busines day 2   on friday will return tuesday          param  number of business days  integer        how many business days out do you want      param  start date  string                      strtotime parseable time value      param  ignore holidays  boolean                true false to ignore holidays      param  return format  string                   as specified in php net date     function get next business day  number of business days 1  start date  today   ignore holidays false  return format  m d y             get the start date as a string to time      result   strtotime  start date           now keep adding to today s date until number of business days is 0 and we land on a business day     while   number of business days  gt  0               add one day to the start date          result   strtotime date  Y-m-d   result        1 day                this day counts if it s a weekend and not a holiday  or if we choose to ignore holidays         if  is weekday date  Y-m-d   result    amp  amp     is holiday date  Y-m-d   result        ignore holidays                  number of business days--                 when my  number of business days is exausted I have my final date      return date  return format  result           function is weekend  date           return if this is a weekend date or not      return  date  N   strtotime  date    gt   6      function is weekday  date           return if this is a weekend date or not      return  date  N   strtotime  date    lt  6      function is holiday  date           return if this is a holiday or not          what are my holidays for this year      holidays   array  New Year s Day 2011    gt   12 31 10                            Good Friday    gt   04 06 12                            Memorial Day    gt   05 28 12                            Independence Day    gt   07 04 12                            Floating Holiday    gt   12 31 12                            Labor Day    gt   09 03 12                            Thanksgiving Day    gt   11 22 12                            Day After Thanksgiving Day    gt   11 23 12                            Christmas Eve    gt   12 24 12                            Christmas Day    gt   12 25 12                            New Year s Day 2012    gt   01 02 12                            New Year s Day 2013    gt   01 01 13                                  return in array date  m d y   strtotime  date    holidays        print get next business day 1      n

User · Answer

I figured you might want to include a list of UK holidays  so here s that    lt  php  class ProductionDays        private function getHolidays                   from https   www gov uk bank-holidays json          holidaysData      england-and-wales    division   england-and-wales   events     title   New Year   s Day   date   2015-01-01   notes      bunting  true    title   Good Friday   date   2015-04-03   notes      bunting  false    title   Easter Monday   date   2015-04-06   notes      bunting  true    title   Early May bank holiday   date   2015-05-04   notes      bunting  true    title   Spring bank holiday   date   2015-05-25   notes      bunting  true    title   Summer bank holiday   date   2015-08-31   notes      bunting  true    title   Christmas Day   date   2015-12-25   notes      bunting  true    title   Boxing Day   date   2015-12-28   notes   Substitute day   bunting  true    title   New Year   s Day   date   2016-01-01   notes      bunting  true    title   Good Friday   date   2016-03-25   notes      bunting  false    title   Easter Monday   date   2016-03-28   notes      bunting  true    title   Early May bank holiday   date   2016-05-02   notes      bunting  true    title   Spring bank holiday   date   2016-05-30   notes      bunting  true    title   Summer bank holiday   date   2016-08-29   notes      bunting  true    title   Boxing Day   date   2016-12-26   notes      bunting  true    title   Christmas Day   date   2016-12-27   notes   Substitute day   bunting  true    title   New Year   s Day   date   2017-01-02   notes   Substitute day   bunting  true    title   Good Friday   date   2017-04-14   notes      bunting  false    title   Easter Monday   date   2017-04-17   notes      bunting  true    title   Early May bank holiday   date   2017-05-01   notes      bunting  true    title   Spring bank holiday   date   2017-05-29   notes      bunting  true    title   Summer bank holiday   date   2017-08-28   notes      bunting  true    title   Christmas Day   date   2017-12-25   notes      bunting  true    title   Boxing Day   date   2017-12-26   notes      bunting  true    title   New Year   s Day   date   2018-01-01   notes      bunting  true    title   Good Friday   date   2018-03-30   notes      bunting  false    title   Easter Monday   date   2018-04-02   notes      bunting  true    title   Early May bank holiday   date   2018-05-07   notes      bunting  true    title   Spring bank holiday   date   2018-05-28   notes      bunting  true    title   Summer bank holiday   date   2018-08-27   notes      bunting  true    title   Christmas Day   date   2018-12-25   notes      bunting  true    title   Boxing Day   date   2018-12-26   notes      bunting  true    title   New Year   s Day   date   2019-01-01   notes      bunting  true    title   Good Friday   date   2019-04-19   notes      bunting  false    title   Easter Monday   date   2019-04-22   notes      bunting  true    title   Early May bank holiday   date   2019-05-06   notes      bunting  true    title   Spring bank holiday   date   2019-05-27   notes      bunting  true    title   Summer bank holiday   date   2019-08-26   notes      bunting  true    title   Christmas Day   date   2019-12-25   notes      bunting  true    title   Boxing Day   date   2019-12-26   notes      bunting  true    title   New Year   s Day   date   2020-01-01   notes      bunting  true    title   Good Friday   date   2020-04-10   notes      bunting  false    title   Easter Monday   date   2020-04-13   notes      bunting  true    title   Early May bank holiday  VE day    date   2020-05-08   notes      bunting  true    title   Spring bank holiday   date   2020-05-25   notes      bunting  true    title   Summer bank holiday   date   2020-08-31   notes      bunting  true    title   Christmas Day   date   2020-12-25   notes      bunting  true    title   Boxing Day   date   2020-12-28   notes   Substitute day   bunting  true    title   New Year   s Day   date   2021-01-01   notes      bunting  true    title   Good Friday   date   2021-04-02   notes      bunting  false    title   Easter Monday   date   2021-04-05   notes      bunting  true    title   Early May bank holiday   date   2021-05-03   notes      bunting  true    title   Spring bank holiday   date   2021-05-31   notes      bunting  true    title   Summer bank holiday   date   2021-08-30   notes      bunting  true    title   Christmas Day   date   2021-12-27   notes   Substitute day   bunting  true    title   Boxing Day   date   2021-12-28   notes   Substitute day   bunting  true     scotland    division   scotland   events     title   New Year   s Day   date   2015-01-01   notes      bunting  true    title   2nd January   date   2015-01-02   notes      bunting  true    title   Good Friday   date   2015-04-03   notes      bunting  false    title   Early May bank holiday   date   2015-05-04   notes      bunting  true    title   Spring bank holiday   date   2015-05-25   notes      bunting  true    title   Summer bank holiday   date   2015-08-03   notes      bunting  true    title   St Andrew   s Day   date   2015-11-30   notes      bunting  true    title   Christmas Day   date   2015-12-25   notes      bunting  true    title   Boxing Day   date   2015-12-28   notes   Substitute day   bunting  true    title   New Year   s Day   date   2016-01-01   notes      bunting  true    title   2nd January   date   2016-01-04   notes   Substitute day   bunting  true    title   Good Friday   date   2016-03-25   notes      bunting  false    title   Early May bank holiday   date   2016-05-02   notes      bunting  true    title   Spring bank holiday   date   2016-05-30   notes      bunting  true    title   Summer bank holiday   date   2016-08-01   notes      bunting  true    title   St Andrew   s Day   date   2016-11-30   notes      bunting  true    title   Boxing Day   date   2016-12-26   notes      bunting  true    title   Christmas Day   date   2016-12-27   notes   Substitute day   bunting  true    title   2nd January   date   2017-01-02   notes      bunting  true    title   New Year   s Day   date   2017-01-03   notes   Substitute day   bunting  true    title   Good Friday   date   2017-04-14   notes      bunting  false    title   Early May bank holiday   date   2017-05-01   notes      bunting  true    title   Spring bank holiday   date   2017-05-29   notes      bunting  true    title   Summer bank holiday   date   2017-08-07   notes      bunting  true    title   St Andrew   s Day   date   2017-11-30   notes      bunting  true    title   Christmas Day   date   2017-12-25   notes      bunting  true    title   Boxing Day   date   2017-12-26   notes      bunting  true    title   New Year   s Day   date   2018-01-01   notes      bunting  true    title   2nd January   date   2018-01-02   notes      bunting  true    title   Good Friday   date   2018-03-30   notes      bunting  false    title   Early May bank holiday   date   2018-05-07   notes      bunting  true    title   Spring bank holiday   date   2018-05-28   notes      bunting  true    title   Summer bank holiday   date   2018-08-06   notes      bunting  true    title   St Andrew   s Day   date   2018-11-30   notes      bunting  true    title   Christmas Day   date   2018-12-25   notes      bunting  true    title   Boxing Day   date   2018-12-26   notes      bunting  true    title   New Year   s Day   date   2019-01-01   notes      bunting  true    title   2nd January   date   2019-01-02   notes      bunting  true    title   Good Friday   date   2019-04-19   notes      bunting  false    title   Early May bank holiday   date   2019-05-06   notes      bunting  true    title   Spring bank holiday   date   2019-05-27   notes      bunting  true    title   Summer bank holiday   date   2019-08-05   notes      bunting  true    title   St Andrew   s Day   date   2019-12-02   notes   Substitute day   bunting  true    title   Christmas Day   date   2019-12-25   notes      bunting  true    title   Boxing Day   date   2019-12-26   notes      bunting  true    title   New Year   s Day   date   2020-01-01   notes      bunting  true    title   2nd January   date   2020-01-02   notes      bunting  true    title   Good Friday   date   2020-04-10   notes      bunting  false    title   Early May bank holiday  VE day    date   2020-05-08   notes      bunting  true    title   Spring bank holiday   date   2020-05-25   notes      bunting  true    title   Summer bank holiday   date   2020-08-03   notes      bunting  true    title   St Andrew   s Day   date   2020-11-30   notes      bunting  true    title   Christmas Day   date   2020-12-25   notes      bunting  true    title   Boxing Day   date   2020-12-28   notes   Substitute day   bunting  true    title   New Year   s Day   date   2021-01-01   notes      bunting  true    title   2nd January   date   2021-01-04   notes   Substitute day   bunting  true    title   Good Friday   date   2021-04-02   notes      bunting  false    title   Early May bank holiday   date   2021-05-03   notes      bunting  true    title   Spring bank holiday   date   2021-05-31   notes      bunting  true    title   Summer bank holiday   date   2021-08-02   notes      bunting  true    title   St Andrew   s Day   date   2021-11-30   notes      bunting  true    title   Christmas Day   date   2021-12-27   notes   Substitute day   bunting  true    title   Boxing Day   date   2021-12-28   notes   Substitute day   bunting  true     northern-ireland    division   northern-ireland   events     title   New Year   s Day   date   2015-01-01   notes      bunting  true    title   St Patrick   s Day   date   2015-03-17   notes      bunting  true    title   Good Friday   date   2015-04-03   notes      bunting  false    title   Easter Monday   date   2015-04-06   notes      bunting  true    title   Early May bank holiday   date   2015-05-04   notes      bunting  true    title   Spring bank holiday   date   2015-05-25   notes      bunting  true    title   Battle of the Boyne  Orangemen   s Day    date   2015-07-13   notes   Substitute day   bunting  false    title   Summer bank holiday   date   2015-08-31   notes      bunting  true    title   Christmas Day   date   2015-12-25   notes      bunting  true    title   Boxing Day   date   2015-12-28   notes   Substitute day   bunting  true    title   New Year   s Day   date   2016-01-01   notes      bunting  true    title   St Patrick   s Day   date   2016-03-17   notes      bunting  true    title   Good Friday   date   2016-03-25   notes      bunting  false    title   Easter Monday   date   2016-03-28   notes      bunting  true    title   Early May bank holiday   date   2016-05-02   notes      bunting  true    title   Spring bank holiday   date   2016-05-30   notes      bunting  true    title   Battle of the Boyne  Orangemen   s Day    date   2016-07-12   notes      bunting  false    title   Summer bank holiday   date   2016-08-29   notes      bunting  true    title   Boxing Day   date   2016-12-26   notes      bunting  true    title   Christmas Day   date   2016-12-27   notes   Substitute day   bunting  true    title   New Year   s Day   date   2017-01-02   notes   Substitute day   bunting  true    title   St Patrick   s Day   date   2017-03-17   notes      bunting  true    title   Good Friday   date   2017-04-14   notes      bunting  false    title   Easter Monday   date   2017-04-17   notes      bunting  true    title   Early May bank holiday   date   2017-05-01   notes      bunting  true    title   Spring bank holiday   date   2017-05-29   notes      bunting  true    title   Battle of the Boyne  Orangemen   s Day    date   2017-07-12   notes      bunting  false    title   Summer bank holiday   date   2017-08-28   notes      bunting  true    title   Christmas Day   date   2017-12-25   notes      bunting  true    title   Boxing Day   date   2017-12-26   notes      bunting  true    title   New Year   s Day   date   2018-01-01   notes      bunting  true    title   St Patrick   s Day   date   2018-03-19   notes   Substitute day   bunting  true    title   Good Friday   date   2018-03-30   notes      bunting  false    title   Easter Monday   date   2018-04-02   notes      bunting  true    title   Early May bank holiday   date   2018-05-07   notes      bunting  true    title   Spring bank holiday   date   2018-05-28   notes      bunting  true    title   Battle of the Boyne  Orangemen   s Day    date   2018-07-12   notes      bunting  false    title   Summer bank holiday   date   2018-08-27   notes      bunting  true    title   Christmas Day   date   2018-12-25   notes      bunting  true    title   Boxing Day   date   2018-12-26   notes      bunting  true    title   New Year   s Day   date   2019-01-01   notes      bunting  true    title   St Patrick   s Day   date   2019-03-18   notes   Substitute day   bunting  true    title   Good Friday   date   2019-04-19   notes      bunting  false    title   Easter Monday   date   2019-04-22   notes      bunting  true    title   Early May bank holiday   date   2019-05-06   notes      bunting  true    title   Spring bank holiday   date   2019-05-27   notes      bunting  true    title   Battle of the Boyne  Orangemen   s Day    date   2019-07-12   notes      bunting  false    title   Summer bank holiday   date   2019-08-26   notes      bunting  true    title   Christmas Day   date   2019-12-25   notes      bunting  true    title   Boxing Day   date   2019-12-26   notes      bunting  true    title   New Year   s Day   date   2020-01-01   notes      bunting  true    title   St Patrick   s Day   date   2020-03-17   notes      bunting  true    title   Good Friday   date   2020-04-10   notes      bunting  false    title   Easter Monday   date   2020-04-13   notes      bunting  true    title   Early May bank holiday  VE day    date   2020-05-08   notes      bunting  true    title   Spring bank holiday   date   2020-05-25   notes      bunting  true    title   Battle of the Boyne  Orangemen   s Day    date   2020-07-13   notes   Substitute day   bunting  false    title   Summer bank holiday   date   2020-08-31   notes      bunting  true    title   Christmas Day   date   2020-12-25   notes      bunting  true    title   Boxing Day   date   2020-12-28   notes   Substitute day   bunting  true    title   New Year   s Day   date   2021-01-01   notes      bunting  true    title   St Patrick   s Day   date   2021-03-17   notes      bunting  true    title   Good Friday   date   2021-04-02   notes      bunting  false    title   Easter Monday   date   2021-04-05   notes      bunting  true    title   Early May bank holiday   date   2021-05-03   notes      bunting  true    title   Spring bank holiday   date   2021-05-31   notes      bunting  true    title   Battle of the Boyne  Orangemen   s Day    date   2021-07-12   notes      bunting  false    title   Summer bank holiday   date   2021-08-30   notes      bunting  true    title   Christmas Day   date   2021-12-27   notes   Substitute day   bunting  true    title   Boxing Day   date   2021-12-28   notes   Substitute day   bunting  true                 holidaysArray   json decode  holidaysData  true            holidays               foreach   holidaysArray  england-and-wales    events   as  event                 holidays      event  date                      return  holidays             public function getWorkingDays  dateFrom   dateTo                 holidays    this- gt getHolidays             startDate   new DateTime  dateFrom            endDate   new DateTime  dateTo            interval   new DateInterval  P1D             dateRange   new DatePeriod  startDate   interval   endDate            results               foreach   dateRange as  date                if   date- gt format  N    lt  6  amp  amp   in array  date- gt format  Y-m-d     holidays                      results      date- gt format  Y-m-d                                    return  results             dateFrom    01-01-2020    dateTo    31-01-2020     productionDays   new ProductionDays     getWorkingDays    productionDays- gt getWorkingDays  dateFrom   dateTo    echo json encode  getWorkingDays

User · Answer

Here is a recursive solution  It can easily be modified to only keep track of and return the latest date       Returns a  numBusDays-sized array of all business dates       starting from and including  currentDate       Any date in  holidays will be skipped over   function getWorkingDays  currentDate   numBusDays   holidays   array        resultDates   array            exit when we have collected the required number of business days   if   numBusDays     0        return  resultDates             add current date to return array  if not a weekend or holiday    date   date  w   strtotime  currentDate      if    date    0   amp  amp    date    6   amp  amp    in array  currentDate   holidays           resultDates      currentDate       numBusDays -  1             set up the next date to test    currentDate   new DateTime   currentDate   1 day       currentDate    currentDate- gt format  Y-m-d       return getWorkingDays  currentDate   numBusDays   holidays   resultDates          test  days   getWorkingDays  2008-12-05   4   print r  days

User · Answer

I had this same need i started with bobbin s first example and ended up with this    function add business days  startdate  buisnessdays  holidays array    dateformat        enddate   strtotime  startdate        day   date  N   enddate       while  buisnessdays  gt  1            enddate   strtotime date  Y-m-d   enddate     1 day             day   date  N   enddate           if  day  lt  6  amp  amp   in array  enddate  holidays   buisnessdays--            return date  dateformat  enddate         hth someone

User · Answer

This code snippet is very easy to calculate business day without week end and holidays   function getWorkingDays  startDate  endDate  offdays  holidays    endDate   strtotime  endDate    startDate   strtotime  startDate    days     endDate -  startDate    86400   1   counter 0  for   i   1   i  lt    days   i           the first day of week   date  N    startDate        startDate  86400  if   in array  the first day of week   offdays   amp  amp   in array date  Y-m- d   startDate    holidays      counter            return  counter      example to use  holidays array  2017-07-03   2017-07-20     offdays array 5 6    weekend days Monday 1      Sunday 7 echo getWorkingDays  2017-01-01   2017-12-31   offdays  holidays

User · Answer

Here s a function from the user comments on the date   function page in the PHP manual  It s an improvement of an earlier function in the comments that adds support for leap years   Enter the starting and ending dates  along with an array of any holidays that might be in between  and it returns the working days as an integer    lt  php   The function returns the no  of business days between two dates and it skips the holidays function getWorkingDays  startDate  endDate  holidays          do strtotime calculations just once      endDate   strtotime  endDate        startDate   strtotime  startDate           The total number of days between the two dates  We compute the no  of seconds and divide it to 60 60 24       We add one to inlude both dates in the interval       days     endDate -  startDate    86400   1        no full weeks   floor  days   7        no remaining days   fmod  days  7          It will return 1 if it s Monday     7 for Sunday      the first day of week   date  N    startDate        the last day of week   date  N    endDate          ---- gt The two can be equal in leap years when february has 29 days  the equal sign is added here       In the first case the whole interval is within a week  in the second case the interval falls in two weeks      if   the first day of week  lt    the last day of week            if   the first day of week  lt   6  amp  amp  6  lt    the last day of week   no remaining days--          if   the first day of week  lt   7  amp  amp  7  lt    the last day of week   no remaining days--            else               edit by Tokes to fix an edge case where the start day was a Sunday            and the end day was NOT a Saturday              the day of the week for start is later than the day of the week for end         if   the first day of week    7                   if the start date is a Sunday  then we definitely subtract 1 day              no remaining days--               if   the last day of week    6                       if the end date is a Saturday  then we subtract another day                  no remaining days--                                  else                  the start date was a Saturday  or earlier   and the end date was  Mon  Fri                 so we skip an entire weekend and subtract 2 days              no remaining days -  2                         The no  of business days is   number of weeks between the two dates     5 working days    the remainder   ---- gt february in none leap years gave a remainder of 0 but still calculated weekends between first and last day  this is one way to fix it     workingDays    no full weeks   5      if   no remaining days  gt  0                workingDays     no remaining days               We subtract the holidays     foreach  holidays as  holiday            time stamp strtotime  holiday             If the holiday doesn t fall in weekend         if   startDate  lt    time stamp  amp  amp   time stamp  lt    endDate  amp  amp  date  N   time stamp     6  amp  amp  date  N   time stamp     7               workingDays--             return  workingDays       Example    holidays array  2008-12-25   2008-12-26   2009-01-01     echo getWorkingDays  2008-12-22   2009-01-02   holidays       gt  will return 7   gt

User · Answer

There are some args for the date   function that should help  If you check date  w   it will give you a number for the day of the week  from 0 for Sunday through 6 for Saturday  So   maybe something like     busDays   3   day   date  w    if   day  gt  2  amp  amp   day  lt   5        if between Wed and Fri       day    2     add 2 more days for weekend       day     busDays    This is just a rough example of one possibility

User · Answer

lt  php  function AddWorkDays     i   0   d   5     Number of days to add      while  i  lt    d         i            if date  N   mktime 0  0  0  date m   date d   i  date Y     lt  5                 d                        return date Y      date m       date d   d       gt

User · Answer

For holidays  make an array of days in some format that date   can produce  Example      I know  these aren t holidays  holidays   array       Jan 2        Feb 3        Mar 5        Apr 7                   Then use the in array   and date   functions to check if the timestamp represents a holiday    day of year   date  M j    timestamp    is holiday   in array  day of year   holidays

User · Answer

You can try this function which is more simple   function getWorkingDays  startDate   endDate         begin   strtotime  startDate        end     strtotime  endDate       if   begin  gt   end             return 0        else            no days    0          while   begin  lt    end                 what day   date  N    begin               if   in array  what day   6 7        6 and 7 are weekend                  no days                 begin    86400      1 day                     return  no days

User · Answer

Thanks to Bobbin  mcgrailm  Tony  James Pasta and a few others who posted here  I had written my own function to add business days to a date  but modified it with some code I found here  This will handle the start date being on a weekend holiday  This will also handle business hours  I added some comments and break up the code to make it easier to read    lt  php function count business days  date   days   holidays         date   strtotime  date        for   i   1   i  lt   intval  days    i        Loops each day count            First  find the next available weekday because this might be a weekend holiday         while  date  N    date   gt   6    in array date  Y-m-d    date    holidays                 date   strtotime date  Y-m-d   date     1 day                         Now that we know we have a business day  add 1 day to it          date   strtotime date  Y-m-d   date     1 day               If this day that was previously added falls on a weekend holiday  then find the next business day         while  date  N    date   gt   6    in array date  Y-m-d    date    holidays                 date   strtotime date  Y-m-d   date     1 day                        return date  Y-m-d    date        Also add in the code from Tony and James Pasta to handle holidays     function getNationalAmericanHolidays  year     bankHolidays   array       New Years Day    gt   year    -01-01        Martin Luther King Jr Birthday    gt      date  Y-m-d  strtotime  third Monday of January      year          Washingtons Birthday    gt      date  Y-m-d  strtotime  third Monday of February      year          Memorial Day    gt      date  Y-m-d  strtotime  last Monday of May      year          Independance Day    gt   year    -07-04        Labor Day    gt      date  Y-m-d  strtotime  first Monday of September      year          Columbus Day    gt      date  Y-m-d  strtotime  second Monday of October      year          Veterans Day    gt   year    -11-11        Thanksgiving Day    gt      date  Y-m-d  strtotime  fourth Thursday of November      year          Christmas Day    gt   year    -12-25     return  bankHolidays        Now to call it    since we re working with business days  we should   also be working with business hours so check if it s after 5 PM   and go to the next day if necessary     Go to next day if after 5 pm  5 pm   17  if  date G   gt   17         start date   date  Y-m-d   strtotime    1 day       Tomorrow   else        start date   date  Y-m-d      Today      Get the holidays for the current year and also for the next year  this year   getNationalAmericanHolidays date  Y      next year   getNationalAmericanHolidays date  Y   strtotime   12 months       holidays   array merge  this year   next year      The number of days to count  days count   10   echo count business days  start date   days count   holidays      gt

User · Answer

Just finished writing an API that can be used to manipulate business days  none of these solutions quite worked for my situation  -   linking to it here in case anyone else finds it useful     Nate  PHP Class to Calculate Business Days

User · Answer

Personally  I think this is a cleaner and more concise solution   function onlyWorkDays   d          holidays   array  2013-12-25   2013-12-31   2014-01-01   2014-01-20   2014-02-17   2014-05-26   2014-07-04   2014-09-01   2014-10-13   2014-11-11   2014-11-27   2014-12-25   2014-12-31        while  in array  d- gt format  Y-m-d     holidays        HOLIDAYS          d- gt sub new DateInterval  P1D               if   d- gt format  w      6       SATURDAY          d- gt sub new DateInterval  P1D               if   d- gt format  w      0       SUNDAY          d- gt sub new DateInterval  P2D               return  d      Just send the proposed new date to this function

User · Answer

A function to add or subtract business days from a given date  this doesn t account for holidays   function dateFromBusinessDays  days   dateTime null       dateTime   is null  dateTime    time      dateTime      day   0      direction    days    0   0   intval  days abs  days        day value    60   60   24      while   day      days         dateTime      direction     day value         day w   date  w    dateTime       if    day w  gt  0  amp  amp    day w  lt  6            day      direction   1                return  dateTime      use like so     echo date  m d Y   dateFromBusinessDays -7    echo date  m d Y   dateFromBusinessDays 3  time     3 60 60 24

User · Answer

My version based on the work by  mcgrailm    tweaked because the report needed to be reviewed within 3 business days  and if submitted on a weekend  the counting would start on the following Monday   function business days add  start date   business days   holidays   array           current date   strtotime  start date        business days   intval  business days      Decrement does not work on strings     while   business days  gt  0            if  date  N    current date   lt  6  amp  amp   in array date  Y-m-d    current date    holidays                  business days--                    if   business days  gt  0                 current date   strtotime   1 day    current date                       return  current date      And working out the difference of two dates in terms of business days   function business days diff  start date   end date   holidays   array           business days   0       current date   strtotime  start date        end date   strtotime  end date       while   current date  lt    end date            if  date  N    current date   lt  6  amp  amp   in array date  Y-m-d    current date    holidays                  business days                      if   current date  lt    end date                 current date   strtotime   1 day    current date                       return  business days      As a note  everyone who is using 86400  or 24 60 60  please don t    your forgetting time changes from winter summer time  where a day it not exactly 24 hours  While it s a little slower the strtotime   1 day    timestamp   it much more reliable

User · Answer

There is a Formula   number of days - math round down 10    number of days    business days in a week   days in a week      Tada  you calculate the numbers of business day  in a month  in a week  in a whatever you want   math round down    is a hypothetical method  which implements a mathematical function that rounds down

User · Answer

Below is the working code to calculate working business days from a given date    lt  php  holiday date array   array  2016-01-26    2016-03-07    2016-03-24    2016-03-25    2016-04-15    2016-08-15    2016-09-12    2016-10-11    2016-10-31     date required    2016-03-01    function increase date  date required   holiday date array array     days   15       if  empty  date required             counter 1 0           incremented date               for  i 1   i  lt    days   i                  date   strtotime    i day   strtotime  date required                 day name   date  D    date                incremented date   date  Y-m-d    date               if  day name   Sat    day name   Sun    in array  incremented date   holiday date array   true                    counter 1  1                                  if  counter 1  gt  0               return increase date  incremented date   holiday date array   counter 1            else              return  incremented date                 else          return  invalid            echo increase date  date required   holiday date array  15     gt     output after adding 15 business working days in 2016-03-01 will be  2016-03-23

User · Answer

Just finished writing an API that can be used to manipulate business days  none of these solutions quite worked for my situation  -   linking to it here in case anyone else finds it useful     Nate  PHP Class to Calculate Business Days

User · Answer

Here s a function from the user comments on the date   function page in the PHP manual  It s an improvement of an earlier function in the comments that adds support for leap years   Enter the starting and ending dates  along with an array of any holidays that might be in between  and it returns the working days as an integer    lt  php   The function returns the no  of business days between two dates and it skips the holidays function getWorkingDays  startDate  endDate  holidays          do strtotime calculations just once      endDate   strtotime  endDate        startDate   strtotime  startDate           The total number of days between the two dates  We compute the no  of seconds and divide it to 60 60 24       We add one to inlude both dates in the interval       days     endDate -  startDate    86400   1        no full weeks   floor  days   7        no remaining days   fmod  days  7          It will return 1 if it s Monday     7 for Sunday      the first day of week   date  N    startDate        the last day of week   date  N    endDate          ---- gt The two can be equal in leap years when february has 29 days  the equal sign is added here       In the first case the whole interval is within a week  in the second case the interval falls in two weeks      if   the first day of week  lt    the last day of week            if   the first day of week  lt   6  amp  amp  6  lt    the last day of week   no remaining days--          if   the first day of week  lt   7  amp  amp  7  lt    the last day of week   no remaining days--            else               edit by Tokes to fix an edge case where the start day was a Sunday            and the end day was NOT a Saturday              the day of the week for start is later than the day of the week for end         if   the first day of week    7                   if the start date is a Sunday  then we definitely subtract 1 day              no remaining days--               if   the last day of week    6                       if the end date is a Saturday  then we subtract another day                  no remaining days--                                  else                  the start date was a Saturday  or earlier   and the end date was  Mon  Fri                 so we skip an entire weekend and subtract 2 days              no remaining days -  2                         The no  of business days is   number of weeks between the two dates     5 working days    the remainder   ---- gt february in none leap years gave a remainder of 0 but still calculated weekends between first and last day  this is one way to fix it     workingDays    no full weeks   5      if   no remaining days  gt  0                workingDays     no remaining days               We subtract the holidays     foreach  holidays as  holiday            time stamp strtotime  holiday             If the holiday doesn t fall in weekend         if   startDate  lt    time stamp  amp  amp   time stamp  lt    endDate  amp  amp  date  N   time stamp     6  amp  amp  date  N   time stamp     7               workingDays--             return  workingDays       Example    holidays array  2008-12-25   2008-12-26   2009-01-01     echo getWorkingDays  2008-12-22   2009-01-02   holidays       gt  will return 7   gt

User · Answer

lt  php     today is the UNIX timestamp for today s date  today   time    echo   lt strong gt Today is  ORDER DATE         lt font color  red  gt     date  l  F j  Y    today      lt  font gt  lt  strong gt  lt br  gt  lt br  gt       The numerical representation for day of week  Ex  01 for Monday      07 for Sunday  today numerical   date  N   today      leadtime days holds the numeric value for the number of business days   leadtime days     POST  leadtime       leadtime is the adjusted date for shipdate  shipdate   time     while   leadtime days  gt  0      if   today numerical    5  amp  amp   today numerical    6        shipdate    shipdate    60 60 24      today numerical   date  N   shipdate      leadtime days --      else    shipdate    shipdate    60 60 24      today numerical   date  N   shipdate      echo   lt strong gt Estimated Ship date        lt font color  green  gt     date  l  F j  Y    shipdate      lt  font gt  lt  strong gt      gt

User · Answer

I figured you might want to include a list of UK holidays  so here s that    lt  php  class ProductionDays        private function getHolidays                   from https   www gov uk bank-holidays json          holidaysData      england-and-wales    division   england-and-wales   events     title   New Year   s Day   date   2015-01-01   notes      bunting  true    title   Good Friday   date   2015-04-03   notes      bunting  false    title   Easter Monday   date   2015-04-06   notes      bunting  true    title   Early May bank holiday   date   2015-05-04   notes      bunting  true    title   Spring bank holiday   date   2015-05-25   notes      bunting  true    title   Summer bank holiday   date   2015-08-31   notes      bunting  true    title   Christmas Day   date   2015-12-25   notes      bunting  true    title   Boxing Day   date   2015-12-28   notes   Substitute day   bunting  true    title   New Year   s Day   date   2016-01-01   notes      bunting  true    title   Good Friday   date   2016-03-25   notes      bunting  false    title   Easter Monday   date   2016-03-28   notes      bunting  true    title   Early May bank holiday   date   2016-05-02   notes      bunting  true    title   Spring bank holiday   date   2016-05-30   notes      bunting  true    title   Summer bank holiday   date   2016-08-29   notes      bunting  true    title   Boxing Day   date   2016-12-26   notes      bunting  true    title   Christmas Day   date   2016-12-27   notes   Substitute day   bunting  true    title   New Year   s Day   date   2017-01-02   notes   Substitute day   bunting  true    title   Good Friday   date   2017-04-14   notes      bunting  false    title   Easter Monday   date   2017-04-17   notes      bunting  true    title   Early May bank holiday   date   2017-05-01   notes      bunting  true    title   Spring bank holiday   date   2017-05-29   notes      bunting  true    title   Summer bank holiday   date   2017-08-28   notes      bunting  true    title   Christmas Day   date   2017-12-25   notes      bunting  true    title   Boxing Day   date   2017-12-26   notes      bunting  true    title   New Year   s Day   date   2018-01-01   notes      bunting  true    title   Good Friday   date   2018-03-30   notes      bunting  false    title   Easter Monday   date   2018-04-02   notes      bunting  true    title   Early May bank holiday   date   2018-05-07   notes      bunting  true    title   Spring bank holiday   date   2018-05-28   notes      bunting  true    title   Summer bank holiday   date   2018-08-27   notes      bunting  true    title   Christmas Day   date   2018-12-25   notes      bunting  true    title   Boxing Day   date   2018-12-26   notes      bunting  true    title   New Year   s Day   date   2019-01-01   notes      bunting  true    title   Good Friday   date   2019-04-19   notes      bunting  false    title   Easter Monday   date   2019-04-22   notes      bunting  true    title   Early May bank holiday   date   2019-05-06   notes      bunting  true    title   Spring bank holiday   date   2019-05-27   notes      bunting  true    title   Summer bank holiday   date   2019-08-26   notes      bunting  true    title   Christmas Day   date   2019-12-25   notes      bunting  true    title   Boxing Day   date   2019-12-26   notes      bunting  true    title   New Year   s Day   date   2020-01-01   notes      bunting  true    title   Good Friday   date   2020-04-10   notes      bunting  false    title   Easter Monday   date   2020-04-13   notes      bunting  true    title   Early May bank holiday  VE day    date   2020-05-08   notes      bunting  true    title   Spring bank holiday   date   2020-05-25   notes      bunting  true    title   Summer bank holiday   date   2020-08-31   notes      bunting  true    title   Christmas Day   date   2020-12-25   notes      bunting  true    title   Boxing Day   date   2020-12-28   notes   Substitute day   bunting  true    title   New Year   s Day   date   2021-01-01   notes      bunting  true    title   Good Friday   date   2021-04-02   notes      bunting  false    title   Easter Monday   date   2021-04-05   notes      bunting  true    title   Early May bank holiday   date   2021-05-03   notes      bunting  true    title   Spring bank holiday   date   2021-05-31   notes      bunting  true    title   Summer bank holiday   date   2021-08-30   notes      bunting  true    title   Christmas Day   date   2021-12-27   notes   Substitute day   bunting  true    title   Boxing Day   date   2021-12-28   notes   Substitute day   bunting  true     scotland    division   scotland   events     title   New Year   s Day   date   2015-01-01   notes      bunting  true    title   2nd January   date   2015-01-02   notes      bunting  true    title   Good Friday   date   2015-04-03   notes      bunting  false    title   Early May bank holiday   date   2015-05-04   notes      bunting  true    title   Spring bank holiday   date   2015-05-25   notes      bunting  true    title   Summer bank holiday   date   2015-08-03   notes      bunting  true    title   St Andrew   s Day   date   2015-11-30   notes      bunting  true    title   Christmas Day   date   2015-12-25   notes      bunting  true    title   Boxing Day   date   2015-12-28   notes   Substitute day   bunting  true    title   New Year   s Day   date   2016-01-01   notes      bunting  true    title   2nd January   date   2016-01-04   notes   Substitute day   bunting  true    title   Good Friday   date   2016-03-25   notes      bunting  false    title   Early May bank holiday   date   2016-05-02   notes      bunting  true    title   Spring bank holiday   date   2016-05-30   notes      bunting  true    title   Summer bank holiday   date   2016-08-01   notes      bunting  true    title   St Andrew   s Day   date   2016-11-30   notes      bunting  true    title   Boxing Day   date   2016-12-26   notes      bunting  true    title   Christmas Day   date   2016-12-27   notes   Substitute day   bunting  true    title   2nd January   date   2017-01-02   notes      bunting  true    title   New Year   s Day   date   2017-01-03   notes   Substitute day   bunting  true    title   Good Friday   date   2017-04-14   notes      bunting  false    title   Early May bank holiday   date   2017-05-01   notes      bunting  true    title   Spring bank holiday   date   2017-05-29   notes      bunting  true    title   Summer bank holiday   date   2017-08-07   notes      bunting  true    title   St Andrew   s Day   date   2017-11-30   notes      bunting  true    title   Christmas Day   date   2017-12-25   notes      bunting  true    title   Boxing Day   date   2017-12-26   notes      bunting  true    title   New Year   s Day   date   2018-01-01   notes      bunting  true    title   2nd January   date   2018-01-02   notes      bunting  true    title   Good Friday   date   2018-03-30   notes      bunting  false    title   Early May bank holiday   date   2018-05-07   notes      bunting  true    title   Spring bank holiday   date   2018-05-28   notes      bunting  true    title   Summer bank holiday   date   2018-08-06   notes      bunting  true    title   St Andrew   s Day   date   2018-11-30   notes      bunting  true    title   Christmas Day   date   2018-12-25   notes      bunting  true    title   Boxing Day   date   2018-12-26   notes      bunting  true    title   New Year   s Day   date   2019-01-01   notes      bunting  true    title   2nd January   date   2019-01-02   notes      bunting  true    title   Good Friday   date   2019-04-19   notes      bunting  false    title   Early May bank holiday   date   2019-05-06   notes      bunting  true    title   Spring bank holiday   date   2019-05-27   notes      bunting  true    title   Summer bank holiday   date   2019-08-05   notes      bunting  true    title   St Andrew   s Day   date   2019-12-02   notes   Substitute day   bunting  true    title   Christmas Day   date   2019-12-25   notes      bunting  true    title   Boxing Day   date   2019-12-26   notes      bunting  true    title   New Year   s Day   date   2020-01-01   notes      bunting  true    title   2nd January   date   2020-01-02   notes      bunting  true    title   Good Friday   date   2020-04-10   notes      bunting  false    title   Early May bank holiday  VE day    date   2020-05-08   notes      bunting  true    title   Spring bank holiday   date   2020-05-25   notes      bunting  true    title   Summer bank holiday   date   2020-08-03   notes      bunting  true    title   St Andrew   s Day   date   2020-11-30   notes      bunting  true    title   Christmas Day   date   2020-12-25   notes      bunting  true    title   Boxing Day   date   2020-12-28   notes   Substitute day   bunting  true    title   New Year   s Day   date   2021-01-01   notes      bunting  true    title   2nd January   date   2021-01-04   notes   Substitute day   bunting  true    title   Good Friday   date   2021-04-02   notes      bunting  false    title   Early May bank holiday   date   2021-05-03   notes      bunting  true    title   Spring bank holiday   date   2021-05-31   notes      bunting  true    title   Summer bank holiday   date   2021-08-02   notes      bunting  true    title   St Andrew   s Day   date   2021-11-30   notes      bunting  true    title   Christmas Day   date   2021-12-27   notes   Substitute day   bunting  true    title   Boxing Day   date   2021-12-28   notes   Substitute day   bunting  true     northern-ireland    division   northern-ireland   events     title   New Year   s Day   date   2015-01-01   notes      bunting  true    title   St Patrick   s Day   date   2015-03-17   notes      bunting  true    title   Good Friday   date   2015-04-03   notes      bunting  false    title   Easter Monday   date   2015-04-06   notes      bunting  true    title   Early May bank holiday   date   2015-05-04   notes      bunting  true    title   Spring bank holiday   date   2015-05-25   notes      bunting  true    title   Battle of the Boyne  Orangemen   s Day    date   2015-07-13   notes   Substitute day   bunting  false    title   Summer bank holiday   date   2015-08-31   notes      bunting  true    title   Christmas Day   date   2015-12-25   notes      bunting  true    title   Boxing Day   date   2015-12-28   notes   Substitute day   bunting  true    title   New Year   s Day   date   2016-01-01   notes      bunting  true    title   St Patrick   s Day   date   2016-03-17   notes      bunting  true    title   Good Friday   date   2016-03-25   notes      bunting  false    title   Easter Monday   date   2016-03-28   notes      bunting  true    title   Early May bank holiday   date   2016-05-02   notes      bunting  true    title   Spring bank holiday   date   2016-05-30   notes      bunting  true    title   Battle of the Boyne  Orangemen   s Day    date   2016-07-12   notes      bunting  false    title   Summer bank holiday   date   2016-08-29   notes      bunting  true    title   Boxing Day   date   2016-12-26   notes      bunting  true    title   Christmas Day   date   2016-12-27   notes   Substitute day   bunting  true    title   New Year   s Day   date   2017-01-02   notes   Substitute day   bunting  true    title   St Patrick   s Day   date   2017-03-17   notes      bunting  true    title   Good Friday   date   2017-04-14   notes      bunting  false    title   Easter Monday   date   2017-04-17   notes      bunting  true    title   Early May bank holiday   date   2017-05-01   notes      bunting  true    title   Spring bank holiday   date   2017-05-29   notes      bunting  true    title   Battle of the Boyne  Orangemen   s Day    date   2017-07-12   notes      bunting  false    title   Summer bank holiday   date   2017-08-28   notes      bunting  true    title   Christmas Day   date   2017-12-25   notes      bunting  true    title   Boxing Day   date   2017-12-26   notes      bunting  true    title   New Year   s Day   date   2018-01-01   notes      bunting  true    title   St Patrick   s Day   date   2018-03-19   notes   Substitute day   bunting  true    title   Good Friday   date   2018-03-30   notes      bunting  false    title   Easter Monday   date   2018-04-02   notes      bunting  true    title   Early May bank holiday   date   2018-05-07   notes      bunting  true    title   Spring bank holiday   date   2018-05-28   notes      bunting  true    title   Battle of the Boyne  Orangemen   s Day    date   2018-07-12   notes      bunting  false    title   Summer bank holiday   date   2018-08-27   notes      bunting  true    title   Christmas Day   date   2018-12-25   notes      bunting  true    title   Boxing Day   date   2018-12-26   notes      bunting  true    title   New Year   s Day   date   2019-01-01   notes      bunting  true    title   St Patrick   s Day   date   2019-03-18   notes   Substitute day   bunting  true    title   Good Friday   date   2019-04-19   notes      bunting  false    title   Easter Monday   date   2019-04-22   notes      bunting  true    title   Early May bank holiday   date   2019-05-06   notes      bunting  true    title   Spring bank holiday   date   2019-05-27   notes      bunting  true    title   Battle of the Boyne  Orangemen   s Day    date   2019-07-12   notes      bunting  false    title   Summer bank holiday   date   2019-08-26   notes      bunting  true    title   Christmas Day   date   2019-12-25   notes      bunting  true    title   Boxing Day   date   2019-12-26   notes      bunting  true    title   New Year   s Day   date   2020-01-01   notes      bunting  true    title   St Patrick   s Day   date   2020-03-17   notes      bunting  true    title   Good Friday   date   2020-04-10   notes      bunting  false    title   Easter Monday   date   2020-04-13   notes      bunting  true    title   Early May bank holiday  VE day    date   2020-05-08   notes      bunting  true    title   Spring bank holiday   date   2020-05-25   notes      bunting  true    title   Battle of the Boyne  Orangemen   s Day    date   2020-07-13   notes   Substitute day   bunting  false    title   Summer bank holiday   date   2020-08-31   notes      bunting  true    title   Christmas Day   date   2020-12-25   notes      bunting  true    title   Boxing Day   date   2020-12-28   notes   Substitute day   bunting  true    title   New Year   s Day   date   2021-01-01   notes      bunting  true    title   St Patrick   s Day   date   2021-03-17   notes      bunting  true    title   Good Friday   date   2021-04-02   notes      bunting  false    title   Easter Monday   date   2021-04-05   notes      bunting  true    title   Early May bank holiday   date   2021-05-03   notes      bunting  true    title   Spring bank holiday   date   2021-05-31   notes      bunting  true    title   Battle of the Boyne  Orangemen   s Day    date   2021-07-12   notes      bunting  false    title   Summer bank holiday   date   2021-08-30   notes      bunting  true    title   Christmas Day   date   2021-12-27   notes   Substitute day   bunting  true    title   Boxing Day   date   2021-12-28   notes   Substitute day   bunting  true                 holidaysArray   json decode  holidaysData  true            holidays               foreach   holidaysArray  england-and-wales    events   as  event                 holidays      event  date                      return  holidays             public function getWorkingDays  dateFrom   dateTo                 holidays    this- gt getHolidays             startDate   new DateTime  dateFrom            endDate   new DateTime  dateTo            interval   new DateInterval  P1D             dateRange   new DatePeriod  startDate   interval   endDate            results               foreach   dateRange as  date                if   date- gt format  N    lt  6  amp  amp   in array  date- gt format  Y-m-d     holidays                      results      date- gt format  Y-m-d                                    return  results             dateFrom    01-01-2020    dateTo    31-01-2020     productionDays   new ProductionDays     getWorkingDays    productionDays- gt getWorkingDays  dateFrom   dateTo    echo json encode  getWorkingDays

User · Answer

Holiday calculation is non-standard in each State  I am writing a bank application which I need some hard business rules for but can still only get a rough standard          National American Holidays     param string  year     return array     public static function getNationalAmericanHolidays  year              January 1 - New Year   s Day  Observed          Calc Last Monday in May - Memorial Day  strtotime  last Monday of May 2011            July 4 Independence Day         First monday in september - Labor Day strtotime  first Monday of September 2011           November 11 - Veterans    Day  Observed          Fourth Thursday in November Thanksgiving strtotime  fourth Thursday of November 2011            December 25 - Christmas Day              bankHolidays   array             year    -01-01     New Years               date  Y-m-d  strtotime  last Monday of May      year       Memorial Day            year    -07-04     Independence Day  corrected                date  Y-m-d  strtotime  first Monday of September      year       Labor Day            year    -11-11     Veterans Day               date  Y-m-d  strtotime  fourth Thursday of November      year       Thanksgiving            year    -12-25     XMAS                 return  bankHolidays

User · Answer

Here is a function for adding buisness days to a date   function add business days  startdate  buisnessdays  holidays  dateformat      i 1     dayx   strtotime  startdate     while  i  lt   buisnessdays       day   date  N   dayx       date   date  Y-m-d   dayx      if  day  lt  6  amp  amp   in array  date  holidays   i        dayx   strtotime  date    1 day          return date  dateformat  dayx          Example  date default timezone set  Europe London      startdate    2012-01-08     holidays array  2012-01-10     echo   lt p gt Start date    date  r  strtotime   startdate     echo   lt p gt   add business days  startdate 7  holidays  r      Another post mentions getWorkingDays  from php net comments and included here  but I think it breaks if you start on a Sunday and finish on a work day   Using the following  you ll need to include the getWorkingDays function from previous post    date default timezone set  Europe London       Example    holidays   array  2012-01-10      startDate    2012-01-08     endDate    2012-01-13    echo getWorkingDays   startDate  endDate  holidays     Gives the result as 5 not 4  Sun  08 Jan 2012 00 00 00  0000 weekend Mon  09 Jan 2012 00 00 00  0000 Tue  10 Jan 2012 00 00 00  0000 holiday Wed  11 Jan 2012 00 00 00  0000 Thu  12 Jan 2012 00 00 00  0000 Fri  13 Jan 2012 00 00 00  0000    The following function was used to generate the above        function get working days  startDate  endDate  holidays          debug   true         work   0         nowork   0         dayx   strtotime  startDate          endx   strtotime  endDate         if  debug          echo   lt h1 gt get working days lt  h1 gt           echo  startDate    date  r  strtotime   startDate     lt br gt           echo  endDate    date  r  strtotime   endDate     lt br gt           var dump  holidays          echo   lt p gt Go to work                    while  dayx  lt    endx           day   date  N   dayx           date   date  Y-m-d   dayx          if  debug echo   lt br   gt   date  r   dayx              if  day  gt  5    in array  date  holidays             nowork         if  debug         if  day  gt  5 echo  weekend         else echo  holiday                   else  work            dayx   strtotime  date    1 day                  if  debug         echo   lt p gt No work     nowork   lt br gt          echo  Work     work   lt br gt          echo  Work   no work      nowork  work    lt br gt          echo  All seconds   seconds in a day    floatval strtotime  endDate -strtotime  startDate   floatval 24 60 60                 return  work              date default timezone set  Europe London           Example        holidays array  2012-01-10          startDate    2012-01-08         endDate    2012-01-13     broken      echo getWorkingDays   startDate  endDate  holidays     works      echo get working days   startDate  endDate  holidays     Bring on the holidays

User · Answer

startDate   new DateTime   2013-04-01          intialize start date  endDate   new DateTime   2013-04-30          initialize end date  holiday   array  2013-04-11   2013-04-25       this is assumed list of holiday  interval   new DateInterval  P1D          set the interval as 1 day  daterange   new DatePeriod  startDate   interval   endDate   foreach  daterange as  date   if  date- gt format  N    lt 6 AND  in array  date- gt format  Y-m-d    holiday    result      date- gt format  Y-m-d      echo   lt pre gt   print r  result

User · Answer

Here s a function from the user comments on the date   function page in the PHP manual  It s an improvement of an earlier function in the comments that adds support for leap years   Enter the starting and ending dates  along with an array of any holidays that might be in between  and it returns the working days as an integer    lt  php   The function returns the no  of business days between two dates and it skips the holidays function getWorkingDays  startDate  endDate  holidays          do strtotime calculations just once      endDate   strtotime  endDate        startDate   strtotime  startDate           The total number of days between the two dates  We compute the no  of seconds and divide it to 60 60 24       We add one to inlude both dates in the interval       days     endDate -  startDate    86400   1        no full weeks   floor  days   7        no remaining days   fmod  days  7          It will return 1 if it s Monday     7 for Sunday      the first day of week   date  N    startDate        the last day of week   date  N    endDate          ---- gt The two can be equal in leap years when february has 29 days  the equal sign is added here       In the first case the whole interval is within a week  in the second case the interval falls in two weeks      if   the first day of week  lt    the last day of week            if   the first day of week  lt   6  amp  amp  6  lt    the last day of week   no remaining days--          if   the first day of week  lt   7  amp  amp  7  lt    the last day of week   no remaining days--            else               edit by Tokes to fix an edge case where the start day was a Sunday            and the end day was NOT a Saturday              the day of the week for start is later than the day of the week for end         if   the first day of week    7                   if the start date is a Sunday  then we definitely subtract 1 day              no remaining days--               if   the last day of week    6                       if the end date is a Saturday  then we subtract another day                  no remaining days--                                  else                  the start date was a Saturday  or earlier   and the end date was  Mon  Fri                 so we skip an entire weekend and subtract 2 days              no remaining days -  2                         The no  of business days is   number of weeks between the two dates     5 working days    the remainder   ---- gt february in none leap years gave a remainder of 0 but still calculated weekends between first and last day  this is one way to fix it     workingDays    no full weeks   5      if   no remaining days  gt  0                workingDays     no remaining days               We subtract the holidays     foreach  holidays as  holiday            time stamp strtotime  holiday             If the holiday doesn t fall in weekend         if   startDate  lt    time stamp  amp  amp   time stamp  lt    endDate  amp  amp  date  N   time stamp     6  amp  amp  date  N   time stamp     7               workingDays--             return  workingDays       Example    holidays array  2008-12-25   2008-12-26   2009-01-01     echo getWorkingDays  2008-12-22   2009-01-02   holidays       gt  will return 7   gt

User · Answer

lt  php     today is the UNIX timestamp for today s date  today   time    echo   lt strong gt Today is  ORDER DATE         lt font color  red  gt     date  l  F j  Y    today      lt  font gt  lt  strong gt  lt br  gt  lt br  gt       The numerical representation for day of week  Ex  01 for Monday      07 for Sunday  today numerical   date  N   today      leadtime days holds the numeric value for the number of business days   leadtime days     POST  leadtime       leadtime is the adjusted date for shipdate  shipdate   time     while   leadtime days  gt  0      if   today numerical    5  amp  amp   today numerical    6        shipdate    shipdate    60 60 24      today numerical   date  N   shipdate      leadtime days --      else    shipdate    shipdate    60 60 24      today numerical   date  N   shipdate      echo   lt strong gt Estimated Ship date        lt font color  green  gt     date  l  F j  Y    shipdate      lt  font gt  lt  strong gt      gt

User · Answer

lt  php  function AddWorkDays     i   0   d   5     Number of days to add      while  i  lt    d         i            if date  N   mktime 0  0  0  date m   date d   i  date Y     lt  5                 d                        return date Y      date m       date d   d       gt

User · Answer

Holiday calculation is non-standard in each State  I am writing a bank application which I need some hard business rules for but can still only get a rough standard          National American Holidays     param string  year     return array     public static function getNationalAmericanHolidays  year              January 1 - New Year   s Day  Observed          Calc Last Monday in May - Memorial Day  strtotime  last Monday of May 2011            July 4 Independence Day         First monday in september - Labor Day strtotime  first Monday of September 2011           November 11 - Veterans    Day  Observed          Fourth Thursday in November Thanksgiving strtotime  fourth Thursday of November 2011            December 25 - Christmas Day              bankHolidays   array             year    -01-01     New Years               date  Y-m-d  strtotime  last Monday of May      year       Memorial Day            year    -07-04     Independence Day  corrected                date  Y-m-d  strtotime  first Monday of September      year       Labor Day            year    -11-11     Veterans Day               date  Y-m-d  strtotime  fourth Thursday of November      year       Thanksgiving            year    -12-25     XMAS                 return  bankHolidays

User · Answer

Brute attempt to detect working time - Monday to Friday 8am-4pm   if  date  N   lt 6  amp  amp  date  G   gt 8  amp  amp  date  G   lt 16          we have a working time  or check for holidays

User · Answer

For holidays  make an array of days in some format that date   can produce  Example      I know  these aren t holidays  holidays   array       Jan 2        Feb 3        Mar 5        Apr 7                   Then use the in array   and date   functions to check if the timestamp represents a holiday    day of year   date  M j    timestamp    is holiday   in array  day of year   holidays

User · Answer

I just get my function working based on Bobbin and mcgrailm code  adding some things that worked perfect to me   function add business days  startdate  buisnessdays  holidays  dateformat        enddate   strtotime  startdate        day   date  N   enddate       while  buisnessdays  gt  0      compatible with 1 businessday if I ll need it          enddate   strtotime date  Y-m-d   enddate     1 day             day   date  N   enddate           if  day  lt  6  amp  amp   in array date  Y-m-d   enddate   holidays   buisnessdays--            return date  dateformat  enddate         as a parameter in in array function we should use endate formated to     compare correctly with the holidays array

User · Answer

You can try this function which is more simple   function getWorkingDays  startDate   endDate         begin   strtotime  startDate        end     strtotime  endDate       if   begin  gt   end             return 0        else            no days    0          while   begin  lt    end                 what day   date  N    begin               if   in array  what day   6 7        6 and 7 are weekend                  no days                 begin    86400      1 day                     return  no days

User · Answer

The add business days has a small bug  Try the following with the existing function and the output will be a Saturday   Startdate   Friday Business days to add   1 Holidays array   Add date for the following Monday   I have fixed that in my function below   function add business days  startdate   buisnessdays   holidays   array     dateformat    Y-m-d     i  1   dayx  strtotime  startdate    buisnessdays  ceil  buisnessdays    while  i  lt   buisnessdays         day  date  N   dayx         date  date  Y-m-d   dayx       if  day  lt  6  amp  amp   in array  date  holidays            i          dayx  strtotime  date    1 day          If the calculated day falls on a weekend or is a holiday  then add days to the next business day  day  date  N   dayx    date  date  Y-m-d   dayx    while  day  gt   6    in array  date  holidays          dayx  strtotime  date    1 day         day  date  N   dayx        date  date  Y-m-d   dayx      return date  dateformat   dayx

User · Answer

Personally  I think this is a cleaner and more concise solution   function onlyWorkDays   d          holidays   array  2013-12-25   2013-12-31   2014-01-01   2014-01-20   2014-02-17   2014-05-26   2014-07-04   2014-09-01   2014-10-13   2014-11-11   2014-11-27   2014-12-25   2014-12-31        while  in array  d- gt format  Y-m-d     holidays        HOLIDAYS          d- gt sub new DateInterval  P1D               if   d- gt format  w      6       SATURDAY          d- gt sub new DateInterval  P1D               if   d- gt format  w      0       SUNDAY          d- gt sub new DateInterval  P2D               return  d      Just send the proposed new date to this function

User · Answer

calculate workdays between two dates including holidays and custom workweek  The answer is not that trivial - thus my suggestion would be to use a class where you can configure more than relying on simplistic function  or assuming a fixed locale and culture   To get the date after a certain number of workdays you ll    need to specify what weekdays you ll be working  default to MON-FRI  - the class allows you to enable or disable each weekday individually  need to know that you need to consider public holidays  country and state  to be accurate  e g  https   github com khatfield php-HolidayLibrary blob master Holidays class php or hardcode the data  e g  from http   www feiertagskalender ch  hl en or pay for data-API http   www timeanddate com services api holiday-api html     Functional Approach          param days  int     param  format  string  dateformat  if format defined OTHERWISE int  timestamp       param start  int  timestamp  mktime  default  time     now     param  wk  bit    flags for each workday  0 SUN  6 SAT  1 workday  0 day off     param  holiday  string    list of dates  YYYY-MM-DD  MM-DD      function working days  days   format      start null   week  0 1 1 1 1 1 0    holiday           if is null  start    start   time        if  days  lt   0  return  start      if count  week     7  trigger error  workweek must contain bit-flags for 7 days        if array sum  week     0  trigger error  workweek must contain at least one workday         wd   date  w    start    0 sun  6 sat      time    start      while  days                if           week  wd           amp  amp   in array date  Y-m-d    time    holiday           amp  amp   in array date  m-d    time    holiday            -- days    decrement on workdays          wd   date  w    time    86400     add one day in seconds            time -  86400   include today     return  format   date  format   time    time       simple usage  ten days   working days 10   D F d Y    echo   lt br gt ten workingdays  MON-FRI  disregarding holidays     ten days     work on saturdays and add new years day as holiday  ten days   working days 10   D F d Y   null   0 1 1 1 1 1 1     01-01     echo   lt br gt ten workingdays  MON-SAT  disregarding holidays     ten days

User · Answer

An enhancement to the function offered by James Pasta above  to include all Federal Holidays  and to correct 4th July  was calculated as 4th June above    and to also include the holiday name as the array key            National American Holidays     param string  year     return array     public static function getNationalAmericanHolidays  year         January 1 - New Year s Day  Observed      Third Monday in January - Birthday of Martin Luther King  Jr      Third Monday in February - Washington   s Birthday   President s Day     Last Monday in May - Memorial Day     July 4 - Independence Day     First Monday in September - Labor Day     Second Monday in October - Columbus Day     November 11 - Veterans    Day  Observed      Fourth Thursday in November Thanksgiving Day     December 25 - Christmas Day  bankHolidays   array        New Years Day     gt   year    -01-01         Martin Luther King Jr Birthday     gt      date  Y-m-d  strtotime  third Monday of January      year           Washingtons Birthday     gt      date  Y-m-d  strtotime  third Monday of February      year           Memorial Day     gt      date  Y-m-d  strtotime  last Monday of May      year           Independance Day     gt   year    -07-04         Labor Day     gt      date  Y-m-d  strtotime  first Monday of September      year           Columbus Day     gt      date  Y-m-d  strtotime  second Monday of October      year           Veterans Day     gt   year    -11-11         Thanksgiving Day     gt      date  Y-m-d  strtotime  fourth Thursday of November      year           Christmas Day     gt   year    -12-25      return  bankHolidays

User · Answer

function get business days forward from date  num days   start date      rtn fmt  Y-m-d           start date will default to today      if   start date         start date   date  Y-m-d        business day ct   0    max days   10000    num days      to avoid any possibility of an infinite loop      define holidays  this currently only goes to 2012 because  well  you know     -     if the world is still here after that  you can find more at    http   www opm gov Operating Status Schedules fedhol 2013 asp    always add holidays in order  because the iteration will stop when the holiday is  gt  date being tested   fed holidays array       2010-01-01        2010-01-18        2010-02-15        2010-05-31        2010-07-05        2010-09-06        2010-10-11        2010-11-11        2010-11-25        2010-12-24         2010-12-31        2011-01-17        2011-02-21        2011-05-30        2011-07-04        2011-09-05        2011-10-10        2011-11-11        2011-11-24        2011-12-26         2012-01-02        2012-01-16        2012-02-20        2012-05-28        2012-07-04        2012-09-03        2012-10-08        2012-11-12        2012-11-22        2012-12-25            curr date ymd   date  Y-m-d   strtotime  start date         for   x 1  x lt  max days  x          if  intval  num days   intval  business day ct     return date  rtn fmt  strtotime  curr date ymd           date found - return         get next day to check       curr date ymd   date  Y-m-d    strtotime  start date    x   86400          add 1 day to the current date       is business day   1          check if this is a weekend   1  for Monday  through 7  for Sunday       if   intval date  N  strtotime  curr date ymd     gt  5     is business day   0           check for holiday     foreach  fed holidays as  holiday                if  strtotime  holiday   strtotime  curr date ymd       holiday found                        is business day   0              break 1                     if  strtotime  holiday  gt strtotime  curr date ymd     break 1        past date  stop searching  always add holidays in order                business day ct    business day ct    is business day      increment if this is a business day         if we get here  you are hosed return   ERROR

User · Answer

There are some args for the date   function that should help  If you check date  w   it will give you a number for the day of the week  from 0 for Sunday through 6 for Saturday  So   maybe something like     busDays   3   day   date  w    if   day  gt  2  amp  amp   day  lt   5        if between Wed and Fri       day    2     add 2 more days for weekend       day     busDays    This is just a rough example of one possibility

User · Answer

Variant 1    lt  php       Does not count current day  the date returned is the last business day    Requires PHP 5 1  Using ISO-8601 week       function businessDays  timestamp   false   bDays   2        if  timestamp     false   timestamp   time        while   bDays gt 0             timestamp    86400          if  date  N    timestamp  lt 6   bDays--            return  timestamp      Variant 2    lt  php       Does not count current day  the date returned is a business day     following the last business day    Requires PHP 5 1  Using ISO-8601 week       function businessDays  timestamp   false   bDays   2        if  timestamp     false   timestamp   time        while   bDays 1 gt 0             timestamp    86400          if  date  N    timestamp  lt 6   bDays--            return  timestamp      Variant 3    lt  php       Does not count current day  the date returned is     a date following the last business day  can be weekend or not      See above for alternatives     Requires PHP 5 1  Using ISO-8601 week       function businessDays  timestamp   false   bDays   2        if  timestamp     false   timestamp   time        while   bDays gt 0             timestamp    86400          if  date  N    timestamp  lt 6   bDays--            return  timestamp    86400      The additional holiday considerations can be made using variations of the above by doing the following  Note  assure all the timestamps are the same time of the day  i e  midnight     Make an array of holiday dates  as unixtimestamps  i e     holidays   array flip strtotime  2011-01-01   strtotime  2011-12-25       Modify line     if  date  N    timestamp  lt 6   bDays--    to be    if  date  N    timestamp  lt 6  amp  amp   isset  holidays  timestamp     bDays--    Done    lt  php       Does not count current day  the date returned is the last business day    Requires PHP 5 1  Using ISO-8601 week       function businessDays  timestamp   false   bDays   2        if  timestamp     false   timestamp   strtotime date  Y-m-d  time           holidays   array flip strtotime  2011-01-01   strtotime  2011-12-25         while   bDays gt 0             timestamp    86400          if  date  N    timestamp  lt 6  amp  amp   isset  holidays  timestamp     bDays--            return  timestamp

User · Answer

I know I m late to the party  but I use this old set of functions by Marcos J  Montes for figuring out holidays and business days   He took the time to add an algorithm from 1876 for Easter and he added all the major US holidays   This can easily be updated for other countries     Usage  days   30   next working date   nextWorkingDay  days   somedate      add date function function DateAdd  interval   number   date          date time array   getdate  date         die print r  date time array          hours    date time array  hours         minutes    date time array  minutes         seconds    date time array  seconds         month    date time array  mon         day    date time array  mday         year    date time array  year         switch   interval             case  yyyy                year   number              break          case  q                year    number 3               break          case  m                month   number              break          case  y           case  d           case  w                day   number              break          case  ww                day    number 7               break          case  h                hours   number              break          case  n                minutes   number              break          case  s                seconds   number               break                                echo  day      day       timestamp  mktime  hours  minutes  seconds  month  day  year       return  timestamp        the following function get holiday   is based on the work done by    Marcos J  Montes function get holiday  year   month   day of week   week           if      week         amp  amp     week  gt  5       week  lt  1         day of week  gt  6       day of week  lt  0                  day of week must be between 0 and 6  Sun 0      Sat 6    week must be between 1 and 5         return FALSE        else           if    week      week                        lastday   date  t   mktime 0 0 0  month 1  year                 temp    date  w  mktime 0 0 0  month  lastday  year   -  day of week    7            else                temp     day of week - date  w  mktime 0 0 0  month 1  year      7                     if   temp  lt  0                 temp    7                     if    week      week                        day    lastday -  temp            else                day    7    week  - 6    temp                      echo  year       month       day     lt br gt  lt br gt            return format date  year   month   day            function observed day  year   month   day           sat - gt  fri  amp  sun - gt  mon  any exceptions                should check  lastday for bumping forward and  firstday for bumping back         although New Year s  amp  Easter look to be the only holidays that potentially        move to a different month  and both are accounted for        dow   date  w   mktime 0  0  0   month   day   year         if   dow    0             dow    day   1        elseif   dow    6            if    month    1   amp  amp    day    1           New Year s on a Saturday              year--               month   12               dow   31            else                dow    day - 1                  else            dow    day             return format date  year   month   dow      function calculate easter  y           In the text below   intval  var1  var2   represents an integer division neglecting        the remainder  while   is division keeping only the remainder  So 30 7 4  and 30 7 2           This algorithm is from Practical Astronomy With Your Calculator  2nd Edition by Peter        Duffett-Smith  It was originally from Butcher s Ecclesiastical Calendar  published in        1876  This algorithm has also been published in the 1922 book General Astronomy by        Spencer Jones  in The Journal of the British Astronomical Association  Vol 88  page        91  December 1977   and in Astronomical Algorithms  1991  by Jean Meeus         a    y 19       b   intval  y 100        c    y 100       d   intval  b 4        e    b 4       f   intval   b 8  25        g   intval   b- f 1  3        h    19  a  b- d- g 15  30       i   intval  c 4        k    c 4       l    32 2  e 2  i- h- k  7       m   intval   a 11  h 22  l  451        p     h  l-7  m 114  31       EasterMonth   intval   h  l-7  m 114  31          3   March  4   April       EasterDay    p 1         day in Easter Month       return format date  y   EasterMonth   EasterDay       function nextWorkingDay  number days   start date              day counter   0       intCounter   0           if   start date                 today    mktime 0  0  0  date  m      date  d    date  Y           else            start time   strtotime  start date            today    mktime 0  0  0  date  m    start time     date  d    start time   date  Y    start time               while  day counter  lt   number days             working time   DateAdd  d   1   today            working date   date  Y-m-d    working date           if   isWeekend  working date   amp  amp   confirm holiday date  Y-m-d   strtotime  working date                     day counter                       intCounter             today     working time          if   intCounter  gt  1000                  just in case out of control              break                       return  working date    function isWeekend  check date        return  date  N    strtotime  check date    gt  5     function confirm holiday  somedate           if   somedate                 somedate   date  Y-m-d               year   date  Y   strtotime  somedate         blnHoliday   false        newyears     if   somedate    observed day  year  1  1              blnHoliday   true            if   somedate    format date  year  1  1              blnHoliday   true            if   somedate    format date  year  12  31              blnHoliday   true              Martin Luther King     if   somedate    get holiday  year  1  1  3              blnHoliday   true              President s     if   somedate    get holiday  year  2  1  3              blnHoliday   true              easter     if   somedate    calculate easter  year              blnHoliday   true              Memorial     if   somedate    get holiday  year  5  1              blnHoliday   true              july4     if   somedate    observed day  year  7  4              blnHoliday   true              labor     if   somedate    get holiday  year  9  1  1              blnHoliday   true              columbus     if   somedate    get holiday  year  10  1  2              blnHoliday   true              thanks     if   somedate    get holiday  year  11  4  4              blnHoliday   true              xmas     if   somedate    format date  year  12  24              blnHoliday   true            if   somedate    format date  year  12  25              blnHoliday   true            return  blnHoliday

User · Answer

Thanks to Bobbin  mcgrailm  Tony  James Pasta and a few others who posted here  I had written my own function to add business days to a date  but modified it with some code I found here  This will handle the start date being on a weekend holiday  This will also handle business hours  I added some comments and break up the code to make it easier to read    lt  php function count business days  date   days   holidays         date   strtotime  date        for   i   1   i  lt   intval  days    i        Loops each day count            First  find the next available weekday because this might be a weekend holiday         while  date  N    date   gt   6    in array date  Y-m-d    date    holidays                 date   strtotime date  Y-m-d   date     1 day                         Now that we know we have a business day  add 1 day to it          date   strtotime date  Y-m-d   date     1 day               If this day that was previously added falls on a weekend holiday  then find the next business day         while  date  N    date   gt   6    in array date  Y-m-d    date    holidays                 date   strtotime date  Y-m-d   date     1 day                        return date  Y-m-d    date        Also add in the code from Tony and James Pasta to handle holidays     function getNationalAmericanHolidays  year     bankHolidays   array       New Years Day    gt   year    -01-01        Martin Luther King Jr Birthday    gt      date  Y-m-d  strtotime  third Monday of January      year          Washingtons Birthday    gt      date  Y-m-d  strtotime  third Monday of February      year          Memorial Day    gt      date  Y-m-d  strtotime  last Monday of May      year          Independance Day    gt   year    -07-04        Labor Day    gt      date  Y-m-d  strtotime  first Monday of September      year          Columbus Day    gt      date  Y-m-d  strtotime  second Monday of October      year          Veterans Day    gt   year    -11-11        Thanksgiving Day    gt      date  Y-m-d  strtotime  fourth Thursday of November      year          Christmas Day    gt   year    -12-25     return  bankHolidays        Now to call it    since we re working with business days  we should   also be working with business hours so check if it s after 5 PM   and go to the next day if necessary     Go to next day if after 5 pm  5 pm   17  if  date G   gt   17         start date   date  Y-m-d   strtotime    1 day       Tomorrow   else        start date   date  Y-m-d      Today      Get the holidays for the current year and also for the next year  this year   getNationalAmericanHolidays date  Y      next year   getNationalAmericanHolidays date  Y   strtotime   12 months       holidays   array merge  this year   next year      The number of days to count  days count   10   echo count business days  start date   days count   holidays      gt

User · Answer

Here is another solution without for loop for each day    from   new DateTime  first date    to   new DateTime  second date     to- gt modify   1 day     interval    from- gt diff  to    days    interval- gt format   a      extra days   fmod  days  7    workdays        days -  extra days     7     5    first day   date  N   strtotime  first date     last day   date  N   strtotime  1 day   strtotime  second date      extra   0  if  first day  gt   last day       if  first day    7            first day   6            extra    6 -  first day      last day - 1      if  extra  lt  0            extra    extra   -1         if  last day  gt   first day         extra    last day -  first day     days    workdays    extra

User · Answer

calculate workdays between two dates including holidays and custom workweek  The answer is not that trivial - thus my suggestion would be to use a class where you can configure more than relying on simplistic function  or assuming a fixed locale and culture   To get the date after a certain number of workdays you ll    need to specify what weekdays you ll be working  default to MON-FRI  - the class allows you to enable or disable each weekday individually  need to know that you need to consider public holidays  country and state  to be accurate  e g  https   github com khatfield php-HolidayLibrary blob master Holidays class php or hardcode the data  e g  from http   www feiertagskalender ch  hl en or pay for data-API http   www timeanddate com services api holiday-api html     Functional Approach          param days  int     param  format  string  dateformat  if format defined OTHERWISE int  timestamp       param start  int  timestamp  mktime  default  time     now     param  wk  bit    flags for each workday  0 SUN  6 SAT  1 workday  0 day off     param  holiday  string    list of dates  YYYY-MM-DD  MM-DD      function working days  days   format      start null   week  0 1 1 1 1 1 0    holiday           if is null  start    start   time        if  days  lt   0  return  start      if count  week     7  trigger error  workweek must contain bit-flags for 7 days        if array sum  week     0  trigger error  workweek must contain at least one workday         wd   date  w    start    0 sun  6 sat      time    start      while  days                if           week  wd           amp  amp   in array date  Y-m-d    time    holiday           amp  amp   in array date  m-d    time    holiday            -- days    decrement on workdays          wd   date  w    time    86400     add one day in seconds            time -  86400   include today     return  format   date  format   time    time       simple usage  ten days   working days 10   D F d Y    echo   lt br gt ten workingdays  MON-FRI  disregarding holidays     ten days     work on saturdays and add new years day as holiday  ten days   working days 10   D F d Y   null   0 1 1 1 1 1 1     01-01     echo   lt br gt ten workingdays  MON-SAT  disregarding holidays     ten days

User · Answer

https   github com Arbitr108 useful php Here is a class which can estimate the working days into calendar  So after estimation simply add calendar period to the date you need

User · Answer

For holidays  make an array of days in some format that date   can produce  Example      I know  these aren t holidays  holidays   array       Jan 2        Feb 3        Mar 5        Apr 7                   Then use the in array   and date   functions to check if the timestamp represents a holiday    day of year   date  M j    timestamp    is holiday   in array  day of year   holidays

User · Answer

An enhancement to the function offered by James Pasta above  to include all Federal Holidays  and to correct 4th July  was calculated as 4th June above    and to also include the holiday name as the array key            National American Holidays     param string  year     return array     public static function getNationalAmericanHolidays  year         January 1 - New Year s Day  Observed      Third Monday in January - Birthday of Martin Luther King  Jr      Third Monday in February - Washington   s Birthday   President s Day     Last Monday in May - Memorial Day     July 4 - Independence Day     First Monday in September - Labor Day     Second Monday in October - Columbus Day     November 11 - Veterans    Day  Observed      Fourth Thursday in November Thanksgiving Day     December 25 - Christmas Day  bankHolidays   array        New Years Day     gt   year    -01-01         Martin Luther King Jr Birthday     gt      date  Y-m-d  strtotime  third Monday of January      year           Washingtons Birthday     gt      date  Y-m-d  strtotime  third Monday of February      year           Memorial Day     gt      date  Y-m-d  strtotime  last Monday of May      year           Independance Day     gt   year    -07-04         Labor Day     gt      date  Y-m-d  strtotime  first Monday of September      year           Columbus Day     gt      date  Y-m-d  strtotime  second Monday of October      year           Veterans Day     gt   year    -11-11         Thanksgiving Day     gt      date  Y-m-d  strtotime  fourth Thursday of November      year           Christmas Day     gt   year    -12-25      return  bankHolidays

User · Answer

My version based on the work by  mcgrailm    tweaked because the report needed to be reviewed within 3 business days  and if submitted on a weekend  the counting would start on the following Monday   function business days add  start date   business days   holidays   array           current date   strtotime  start date        business days   intval  business days      Decrement does not work on strings     while   business days  gt  0            if  date  N    current date   lt  6  amp  amp   in array date  Y-m-d    current date    holidays                  business days--                    if   business days  gt  0                 current date   strtotime   1 day    current date                       return  current date      And working out the difference of two dates in terms of business days   function business days diff  start date   end date   holidays   array           business days   0       current date   strtotime  start date        end date   strtotime  end date       while   current date  lt    end date            if  date  N    current date   lt  6  amp  amp   in array date  Y-m-d    current date    holidays                  business days                      if   current date  lt    end date                 current date   strtotime   1 day    current date                       return  business days      As a note  everyone who is using 86400  or 24 60 60  please don t    your forgetting time changes from winter summer time  where a day it not exactly 24 hours  While it s a little slower the strtotime   1 day    timestamp   it much more reliable

User · Answer

Here is a function for adding buisness days to a date   function add business days  startdate  buisnessdays  holidays  dateformat      i 1     dayx   strtotime  startdate     while  i  lt   buisnessdays       day   date  N   dayx       date   date  Y-m-d   dayx      if  day  lt  6  amp  amp   in array  date  holidays   i        dayx   strtotime  date    1 day          return date  dateformat  dayx          Example  date default timezone set  Europe London      startdate    2012-01-08     holidays array  2012-01-10     echo   lt p gt Start date    date  r  strtotime   startdate     echo   lt p gt   add business days  startdate 7  holidays  r      Another post mentions getWorkingDays  from php net comments and included here  but I think it breaks if you start on a Sunday and finish on a work day   Using the following  you ll need to include the getWorkingDays function from previous post    date default timezone set  Europe London       Example    holidays   array  2012-01-10      startDate    2012-01-08     endDate    2012-01-13    echo getWorkingDays   startDate  endDate  holidays     Gives the result as 5 not 4  Sun  08 Jan 2012 00 00 00  0000 weekend Mon  09 Jan 2012 00 00 00  0000 Tue  10 Jan 2012 00 00 00  0000 holiday Wed  11 Jan 2012 00 00 00  0000 Thu  12 Jan 2012 00 00 00  0000 Fri  13 Jan 2012 00 00 00  0000    The following function was used to generate the above        function get working days  startDate  endDate  holidays          debug   true         work   0         nowork   0         dayx   strtotime  startDate          endx   strtotime  endDate         if  debug          echo   lt h1 gt get working days lt  h1 gt           echo  startDate    date  r  strtotime   startDate     lt br gt           echo  endDate    date  r  strtotime   endDate     lt br gt           var dump  holidays          echo   lt p gt Go to work                    while  dayx  lt    endx           day   date  N   dayx           date   date  Y-m-d   dayx          if  debug echo   lt br   gt   date  r   dayx              if  day  gt  5    in array  date  holidays             nowork         if  debug         if  day  gt  5 echo  weekend         else echo  holiday                   else  work            dayx   strtotime  date    1 day                  if  debug         echo   lt p gt No work     nowork   lt br gt          echo  Work     work   lt br gt          echo  Work   no work      nowork  work    lt br gt          echo  All seconds   seconds in a day    floatval strtotime  endDate -strtotime  startDate   floatval 24 60 60                 return  work              date default timezone set  Europe London           Example        holidays array  2012-01-10          startDate    2012-01-08         endDate    2012-01-13     broken      echo getWorkingDays   startDate  endDate  holidays     works      echo get working days   startDate  endDate  holidays     Bring on the holidays

User · Answer

This code snippet is very easy to calculate business day without week end and holidays   function getWorkingDays  startDate  endDate  offdays  holidays    endDate   strtotime  endDate    startDate   strtotime  startDate    days     endDate -  startDate    86400   1   counter 0  for   i   1   i  lt    days   i           the first day of week   date  N    startDate        startDate  86400  if   in array  the first day of week   offdays   amp  amp   in array date  Y-m- d   startDate    holidays      counter            return  counter      example to use  holidays array  2017-07-03   2017-07-20     offdays array 5 6    weekend days Monday 1      Sunday 7 echo getWorkingDays  2017-01-01   2017-12-31   offdays  holidays

User · Answer

Brute attempt to detect working time - Monday to Friday 8am-4pm   if  date  N   lt 6  amp  amp  date  G   gt 8  amp  amp  date  G   lt 16          we have a working time  or check for holidays

User · Answer

This is another solution  it is nearly 25  faster than checking holidays with in array          Function to calculate the working days between two days  considering holidays      param string  startDate -- Start date of the range  included   formatted as Y-m-d      param string  endDate -- End date of the range  included   formatted as Y-m-d      param array string   holidayDates -- OPTIONAL  Array of holidays dates  formatted as Y-m-d   e g  array  2016-08-15    2016-12-25        return int -- Number of working days      function getWorkingDays  startDate   endDate   holidayDates array          dateRange   new DatePeriod new DateTime  startDate   new DateInterval  P1D     new DateTime  endDate  - gt modify   1day         foreach   dateRange as  dr    if  dr- gt format  N   lt 6   workingDays    dr- gt format  Y-m-d           return count array diff  workingDays   holidayDates

User · Answer

Although this question has over 35 answers at the time of writing  there is a better solution to this problem   flamingLogos provided an answer which is based on Mathematics and doesn t contain any loops  That solution provides a time complexity of T 1   However  the math behind it is pretty complex especially the leap year handling   Glavic provided a good solution that is minimal and elegant  But it doesn t preform the calculation in a constant time  so it could produce a denial of service  DOS  attack or at least timeout if used with large periods like 10 or 100 of years since it loops on 1 day interval  So I propose a mathematical approach that have constant time and yet very readable  The idea is to count how many days to have complete weeks   lt  php function getWorkingHours  start date   end date           validate input     if  validateDate  start date      validateDate  end date   return   error    gt   Invalid Date        if  end date  lt   start date  return   error    gt   End date must be greater than or equal Start date           We save timezone and switch to UTC to prevent issues      old timezone   date default timezone get        date default timezone set  quot UTC quot          startDate   strtotime  start date        endDate   strtotime  end date          The total number of days between the two dates  We compute the no  of seconds and divide it to 60 60 24       We add one to include both dates in the interval       days     endDate -  startDate    86400   1       no full weeks   ceil  days   7         we get only missing days count to complete full weeks       we take modulo 7 in case it was already full weeks      no of missing days    7 -   days   7     7        workingDays    no full weeks   5        Next we remove the working days we added  this loop will have max of 6 iterations      for   i   1   i  lt    no of missing days   i             if date  N    endDate    i   86400   lt  6   workingDays--              holidays   getHolidays date  Y    startDate   date  Y    endDate           We subtract the holidays     foreach  holidays as  holiday            time stamp strtotime  holiday             If the holiday doesn t fall in weekend         if   startDate  lt    time stamp  amp  amp   time stamp  lt    endDate  amp  amp  date  quot N quot   time stamp     6  amp  amp  date  quot N quot   time stamp     7               workingDays--             date default timezone set  old timezone       return   days    gt   workingDays       The input to the function are in the format of Y-m-d in php or yyyy-mm-dd in general date format  The get holiday function will return an array of holiday dates starting from start year and until end year

User · Answer

There are some args for the date   function that should help  If you check date  w   it will give you a number for the day of the week  from 0 for Sunday through 6 for Saturday  So   maybe something like     busDays   3   day   date  w    if   day  gt  2  amp  amp   day  lt   5        if between Wed and Fri       day    2     add 2 more days for weekend       day     busDays    This is just a rough example of one possibility

User · Answer

Get the number of working days without holidays between two dates    Use example   echo number of working days  2013-12-23    2013-12-29      Output   3   Function   function number of working days  from   to         workingDays    1  2  3  4  5     date format   N  1   Monday            holidayDays      -12-25     -01-01    2013-12-23      variable and fixed holidays       from   new DateTime  from        to   new DateTime  to        to- gt modify   1 day         interval   new DateInterval  P1D         periods   new DatePeriod  from   interval   to         days   0      foreach   periods as  period            if   in array  period- gt format  N     workingDays   continue          if  in array  period- gt format  Y-m-d     holidayDays   continue          if  in array  period- gt format   -m-d     holidayDays   continue           days              return  days

User · Answer

startDate   new DateTime   2013-04-01          intialize start date  endDate   new DateTime   2013-04-30          initialize end date  holiday   array  2013-04-11   2013-04-25       this is assumed list of holiday  interval   new DateInterval  P1D          set the interval as 1 day  daterange   new DatePeriod  startDate   interval   endDate   foreach  daterange as  date   if  date- gt format  N    lt 6 AND  in array  date- gt format  Y-m-d    holiday    result      date- gt format  Y-m-d      echo   lt pre gt   print r  result

User · Answer

I know I m late to the party  but I use this old set of functions by Marcos J  Montes for figuring out holidays and business days   He took the time to add an algorithm from 1876 for Easter and he added all the major US holidays   This can easily be updated for other countries     Usage  days   30   next working date   nextWorkingDay  days   somedate      add date function function DateAdd  interval   number   date          date time array   getdate  date         die print r  date time array          hours    date time array  hours         minutes    date time array  minutes         seconds    date time array  seconds         month    date time array  mon         day    date time array  mday         year    date time array  year         switch   interval             case  yyyy                year   number              break          case  q                year    number 3               break          case  m                month   number              break          case  y           case  d           case  w                day   number              break          case  ww                day    number 7               break          case  h                hours   number              break          case  n                minutes   number              break          case  s                seconds   number               break                                echo  day      day       timestamp  mktime  hours  minutes  seconds  month  day  year       return  timestamp        the following function get holiday   is based on the work done by    Marcos J  Montes function get holiday  year   month   day of week   week           if      week         amp  amp     week  gt  5       week  lt  1         day of week  gt  6       day of week  lt  0                  day of week must be between 0 and 6  Sun 0      Sat 6    week must be between 1 and 5         return FALSE        else           if    week      week                        lastday   date  t   mktime 0 0 0  month 1  year                 temp    date  w  mktime 0 0 0  month  lastday  year   -  day of week    7            else                temp     day of week - date  w  mktime 0 0 0  month 1  year      7                     if   temp  lt  0                 temp    7                     if    week      week                        day    lastday -  temp            else                day    7    week  - 6    temp                      echo  year       month       day     lt br gt  lt br gt            return format date  year   month   day            function observed day  year   month   day           sat - gt  fri  amp  sun - gt  mon  any exceptions                should check  lastday for bumping forward and  firstday for bumping back         although New Year s  amp  Easter look to be the only holidays that potentially        move to a different month  and both are accounted for        dow   date  w   mktime 0  0  0   month   day   year         if   dow    0             dow    day   1        elseif   dow    6            if    month    1   amp  amp    day    1           New Year s on a Saturday              year--               month   12               dow   31            else                dow    day - 1                  else            dow    day             return format date  year   month   dow      function calculate easter  y           In the text below   intval  var1  var2   represents an integer division neglecting        the remainder  while   is division keeping only the remainder  So 30 7 4  and 30 7 2           This algorithm is from Practical Astronomy With Your Calculator  2nd Edition by Peter        Duffett-Smith  It was originally from Butcher s Ecclesiastical Calendar  published in        1876  This algorithm has also been published in the 1922 book General Astronomy by        Spencer Jones  in The Journal of the British Astronomical Association  Vol 88  page        91  December 1977   and in Astronomical Algorithms  1991  by Jean Meeus         a    y 19       b   intval  y 100        c    y 100       d   intval  b 4        e    b 4       f   intval   b 8  25        g   intval   b- f 1  3        h    19  a  b- d- g 15  30       i   intval  c 4        k    c 4       l    32 2  e 2  i- h- k  7       m   intval   a 11  h 22  l  451        p     h  l-7  m 114  31       EasterMonth   intval   h  l-7  m 114  31          3   March  4   April       EasterDay    p 1         day in Easter Month       return format date  y   EasterMonth   EasterDay       function nextWorkingDay  number days   start date              day counter   0       intCounter   0           if   start date                 today    mktime 0  0  0  date  m      date  d    date  Y           else            start time   strtotime  start date            today    mktime 0  0  0  date  m    start time     date  d    start time   date  Y    start time               while  day counter  lt   number days             working time   DateAdd  d   1   today            working date   date  Y-m-d    working date           if   isWeekend  working date   amp  amp   confirm holiday date  Y-m-d   strtotime  working date                     day counter                       intCounter             today     working time          if   intCounter  gt  1000                  just in case out of control              break                       return  working date    function isWeekend  check date        return  date  N    strtotime  check date    gt  5     function confirm holiday  somedate           if   somedate                 somedate   date  Y-m-d               year   date  Y   strtotime  somedate         blnHoliday   false        newyears     if   somedate    observed day  year  1  1              blnHoliday   true            if   somedate    format date  year  1  1              blnHoliday   true            if   somedate    format date  year  12  31              blnHoliday   true              Martin Luther King     if   somedate    get holiday  year  1  1  3              blnHoliday   true              President s     if   somedate    get holiday  year  2  1  3              blnHoliday   true              easter     if   somedate    calculate easter  year              blnHoliday   true              Memorial     if   somedate    get holiday  year  5  1              blnHoliday   true              july4     if   somedate    observed day  year  7  4              blnHoliday   true              labor     if   somedate    get holiday  year  9  1  1              blnHoliday   true              columbus     if   somedate    get holiday  year  10  1  2              blnHoliday   true              thanks     if   somedate    get holiday  year  11  4  4              blnHoliday   true              xmas     if   somedate    format date  year  12  24              blnHoliday   true            if   somedate    format date  year  12  25              blnHoliday   true            return  blnHoliday

User · Answer

For holidays  make an array of days in some format that date   can produce  Example      I know  these aren t holidays  holidays   array       Jan 2        Feb 3        Mar 5        Apr 7                   Then use the in array   and date   functions to check if the timestamp represents a holiday    day of year   date  M j    timestamp    is holiday   in array  day of year   holidays

User · Answer

If you need to get how much time was between two dates you can use https   github com maximnara business-days-counter  It s works simply but only with laravel now  diffInSeconds    this- gt datesCounter- gt getDifferenceInSeconds Carbon  create 2019  1  1   Carbon  now    DateCounter  COUNTRY FR    It doesn t counts public holidays and weekends and you can set working interval  for example from 9 to 18 with launch hour or no   Or if you need just weekends and you use Carbon you can use built in function    date1   Carbon  create 2019  1  1 - gt endOfDay     date2    dt- gt copy  - gt startOfDay     diff    date1- gt diffFiltered CarbonInterval  minute    function Carbon  date       return   date- gt isWeekend        date2  true     But it will foreach every minute in interval  for bit intervals it can take a while

User · Answer

If you need to get how much time was between two dates you can use https   github com maximnara business-days-counter  It s works simply but only with laravel now  diffInSeconds    this- gt datesCounter- gt getDifferenceInSeconds Carbon  create 2019  1  1   Carbon  now    DateCounter  COUNTRY FR    It doesn t counts public holidays and weekends and you can set working interval  for example from 9 to 18 with launch hour or no   Or if you need just weekends and you use Carbon you can use built in function    date1   Carbon  create 2019  1  1 - gt endOfDay     date2    dt- gt copy  - gt startOfDay     diff    date1- gt diffFiltered CarbonInterval  minute    function Carbon  date       return   date- gt isWeekend        date2  true     But it will foreach every minute in interval  for bit intervals it can take a while

User · Answer

Here is another solution without for loop for each day    from   new DateTime  first date    to   new DateTime  second date     to- gt modify   1 day     interval    from- gt diff  to    days    interval- gt format   a      extra days   fmod  days  7    workdays        days -  extra days     7     5    first day   date  N   strtotime  first date     last day   date  N   strtotime  1 day   strtotime  second date      extra   0  if  first day  gt   last day       if  first day    7            first day   6            extra    6 -  first day      last day - 1      if  extra  lt  0            extra    extra   -1         if  last day  gt   first day         extra    last day -  first day     days    workdays    extra

User · Answer

Variant 1    lt  php       Does not count current day  the date returned is the last business day    Requires PHP 5 1  Using ISO-8601 week       function businessDays  timestamp   false   bDays   2        if  timestamp     false   timestamp   time        while   bDays gt 0             timestamp    86400          if  date  N    timestamp  lt 6   bDays--            return  timestamp      Variant 2    lt  php       Does not count current day  the date returned is a business day     following the last business day    Requires PHP 5 1  Using ISO-8601 week       function businessDays  timestamp   false   bDays   2        if  timestamp     false   timestamp   time        while   bDays 1 gt 0             timestamp    86400          if  date  N    timestamp  lt 6   bDays--            return  timestamp      Variant 3    lt  php       Does not count current day  the date returned is     a date following the last business day  can be weekend or not      See above for alternatives     Requires PHP 5 1  Using ISO-8601 week       function businessDays  timestamp   false   bDays   2        if  timestamp     false   timestamp   time        while   bDays gt 0             timestamp    86400          if  date  N    timestamp  lt 6   bDays--            return  timestamp    86400      The additional holiday considerations can be made using variations of the above by doing the following  Note  assure all the timestamps are the same time of the day  i e  midnight     Make an array of holiday dates  as unixtimestamps  i e     holidays   array flip strtotime  2011-01-01   strtotime  2011-12-25       Modify line     if  date  N    timestamp  lt 6   bDays--    to be    if  date  N    timestamp  lt 6  amp  amp   isset  holidays  timestamp     bDays--    Done    lt  php       Does not count current day  the date returned is the last business day    Requires PHP 5 1  Using ISO-8601 week       function businessDays  timestamp   false   bDays   2        if  timestamp     false   timestamp   strtotime date  Y-m-d  time           holidays   array flip strtotime  2011-01-01   strtotime  2011-12-25         while   bDays gt 0             timestamp    86400          if  date  N    timestamp  lt 6  amp  amp   isset  holidays  timestamp     bDays--            return  timestamp

User · Answer

I just get my function working based on Bobbin and mcgrailm code  adding some things that worked perfect to me   function add business days  startdate  buisnessdays  holidays  dateformat        enddate   strtotime  startdate        day   date  N   enddate       while  buisnessdays  gt  0      compatible with 1 businessday if I ll need it          enddate   strtotime date  Y-m-d   enddate     1 day             day   date  N   enddate           if  day  lt  6  amp  amp   in array date  Y-m-d   enddate   holidays   buisnessdays--            return date  dateformat  enddate         as a parameter in in array function we should use endate formated to     compare correctly with the holidays array

User · Answer

date default timezone set  America New York          Given a number days out  what day is that when counting by  business  days     get the next business day  by default it looks for next business day     ie calling   date   get next busines day    on monday will return tuesday                  date   get next busines day 2   on monday will return wednesday                  date   get next busines day 2   on friday will return tuesday          param  number of business days  integer        how many business days out do you want      param  start date  string                      strtotime parseable time value      param  ignore holidays  boolean                true false to ignore holidays      param  return format  string                   as specified in php net date     function get next business day  number of business days 1  start date  today   ignore holidays false  return format  m d y             get the start date as a string to time      result   strtotime  start date           now keep adding to today s date until number of business days is 0 and we land on a business day     while   number of business days  gt  0               add one day to the start date          result   strtotime date  Y-m-d   result        1 day                this day counts if it s a weekend and not a holiday  or if we choose to ignore holidays         if  is weekday date  Y-m-d   result    amp  amp     is holiday date  Y-m-d   result        ignore holidays                  number of business days--                 when my  number of business days is exausted I have my final date      return date  return format  result           function is weekend  date           return if this is a weekend date or not      return  date  N   strtotime  date    gt   6      function is weekday  date           return if this is a weekend date or not      return  date  N   strtotime  date    lt  6      function is holiday  date           return if this is a holiday or not          what are my holidays for this year      holidays   array  New Year s Day 2011    gt   12 31 10                            Good Friday    gt   04 06 12                            Memorial Day    gt   05 28 12                            Independence Day    gt   07 04 12                            Floating Holiday    gt   12 31 12                            Labor Day    gt   09 03 12                            Thanksgiving Day    gt   11 22 12                            Day After Thanksgiving Day    gt   11 23 12                            Christmas Eve    gt   12 24 12                            Christmas Day    gt   12 25 12                            New Year s Day 2012    gt   01 02 12                            New Year s Day 2013    gt   01 01 13                                  return in array date  m d y   strtotime  date    holidays        print get next business day 1      n

User · Answer

function get business days forward from date  num days   start date      rtn fmt  Y-m-d           start date will default to today      if   start date         start date   date  Y-m-d        business day ct   0    max days   10000    num days      to avoid any possibility of an infinite loop      define holidays  this currently only goes to 2012 because  well  you know     -     if the world is still here after that  you can find more at    http   www opm gov Operating Status Schedules fedhol 2013 asp    always add holidays in order  because the iteration will stop when the holiday is  gt  date being tested   fed holidays array       2010-01-01        2010-01-18        2010-02-15        2010-05-31        2010-07-05        2010-09-06        2010-10-11        2010-11-11        2010-11-25        2010-12-24         2010-12-31        2011-01-17        2011-02-21        2011-05-30        2011-07-04        2011-09-05        2011-10-10        2011-11-11        2011-11-24        2011-12-26         2012-01-02        2012-01-16        2012-02-20        2012-05-28        2012-07-04        2012-09-03        2012-10-08        2012-11-12        2012-11-22        2012-12-25            curr date ymd   date  Y-m-d   strtotime  start date         for   x 1  x lt  max days  x          if  intval  num days   intval  business day ct     return date  rtn fmt  strtotime  curr date ymd           date found - return         get next day to check       curr date ymd   date  Y-m-d    strtotime  start date    x   86400          add 1 day to the current date       is business day   1          check if this is a weekend   1  for Monday  through 7  for Sunday       if   intval date  N  strtotime  curr date ymd     gt  5     is business day   0           check for holiday     foreach  fed holidays as  holiday                if  strtotime  holiday   strtotime  curr date ymd       holiday found                        is business day   0              break 1                     if  strtotime  holiday  gt strtotime  curr date ymd     break 1        past date  stop searching  always add holidays in order                business day ct    business day ct    is business day      increment if this is a business day         if we get here  you are hosed return   ERROR

User · Answer

A function to add or subtract business days from a given date  this doesn t account for holidays   function dateFromBusinessDays  days   dateTime null       dateTime   is null  dateTime    time      dateTime      day   0      direction    days    0   0   intval  days abs  days        day value    60   60   24      while   day      days         dateTime      direction     day value         day w   date  w    dateTime       if    day w  gt  0  amp  amp    day w  lt  6            day      direction   1                return  dateTime      use like so     echo date  m d Y   dateFromBusinessDays -7    echo date  m d Y   dateFromBusinessDays 3  time     3 60 60 24

User · Answer

I just created this function  which seems to work very well   function getBusinessDays  date1   date2        if  is numeric  date1             date1   strtotime  date1              if  is numeric  date2             date2   strtotime  date2              if  date2  lt   date1            temp date    date1           date1    date2           date2    temp date          unset  temp date               diff    date2 -  date1        days diff   intval  diff    3600   24         current day of week   intval date  N    date1         business days   0       for  i   1   i  lt    days diff   i             if  in array  current day of week  array  Sunday    gt  1   Saturday    gt  7                  business days                        current day of week            if  current day of week  gt  7                current day of week   1                       return  business days     echo  Business days      getBusinessDays  8 15 2014    8 8 2014

User · Answer

https   github com Arbitr108 useful php Here is a class which can estimate the working days into calendar  So after estimation simply add calendar period to the date you need

User · Answer

This is another solution  it is nearly 25  faster than checking holidays with in array          Function to calculate the working days between two days  considering holidays      param string  startDate -- Start date of the range  included   formatted as Y-m-d      param string  endDate -- End date of the range  included   formatted as Y-m-d      param array string   holidayDates -- OPTIONAL  Array of holidays dates  formatted as Y-m-d   e g  array  2016-08-15    2016-12-25        return int -- Number of working days      function getWorkingDays  startDate   endDate   holidayDates array          dateRange   new DatePeriod new DateTime  startDate   new DateInterval  P1D     new DateTime  endDate  - gt modify   1day         foreach   dateRange as  dr    if  dr- gt format  N   lt 6   workingDays    dr- gt format  Y-m-d           return count array diff  workingDays   holidayDates

User · Answer

PHPClasses have a nice class for this named PHP Working Days  You can check this class

User · Answer

There are some args for the date   function that should help  If you check date  w   it will give you a number for the day of the week  from 0 for Sunday through 6 for Saturday  So   maybe something like     busDays   3   day   date  w    if   day  gt  2  amp  amp   day  lt   5        if between Wed and Fri       day    2     add 2 more days for weekend       day     busDays    This is just a rough example of one possibility

User · Answer

Below is the working code to calculate working business days from a given date    lt  php  holiday date array   array  2016-01-26    2016-03-07    2016-03-24    2016-03-25    2016-04-15    2016-08-15    2016-09-12    2016-10-11    2016-10-31     date required    2016-03-01    function increase date  date required   holiday date array array     days   15       if  empty  date required             counter 1 0           incremented date               for  i 1   i  lt    days   i                  date   strtotime    i day   strtotime  date required                 day name   date  D    date                incremented date   date  Y-m-d    date               if  day name   Sat    day name   Sun    in array  incremented date   holiday date array   true                    counter 1  1                                  if  counter 1  gt  0               return increase date  incremented date   holiday date array   counter 1            else              return  incremented date                 else          return  invalid            echo increase date  date required   holiday date array  15     gt     output after adding 15 business working days in 2016-03-01 will be  2016-03-23

User · Answer

Here is a recursive solution  It can easily be modified to only keep track of and return the latest date       Returns a  numBusDays-sized array of all business dates       starting from and including  currentDate       Any date in  holidays will be skipped over   function getWorkingDays  currentDate   numBusDays   holidays   array        resultDates   array            exit when we have collected the required number of business days   if   numBusDays     0        return  resultDates             add current date to return array  if not a weekend or holiday    date   date  w   strtotime  currentDate      if    date    0   amp  amp    date    6   amp  amp    in array  currentDate   holidays           resultDates      currentDate       numBusDays -  1             set up the next date to test    currentDate   new DateTime   currentDate   1 day       currentDate    currentDate- gt format  Y-m-d       return getWorkingDays  currentDate   numBusDays   holidays   resultDates          test  days   getWorkingDays  2008-12-05   4   print r  days

User · Answer

Here s a function from the user comments on the date   function page in the PHP manual  It s an improvement of an earlier function in the comments that adds support for leap years   Enter the starting and ending dates  along with an array of any holidays that might be in between  and it returns the working days as an integer    lt  php   The function returns the no  of business days between two dates and it skips the holidays function getWorkingDays  startDate  endDate  holidays          do strtotime calculations just once      endDate   strtotime  endDate        startDate   strtotime  startDate           The total number of days between the two dates  We compute the no  of seconds and divide it to 60 60 24       We add one to inlude both dates in the interval       days     endDate -  startDate    86400   1        no full weeks   floor  days   7        no remaining days   fmod  days  7          It will return 1 if it s Monday     7 for Sunday      the first day of week   date  N    startDate        the last day of week   date  N    endDate          ---- gt The two can be equal in leap years when february has 29 days  the equal sign is added here       In the first case the whole interval is within a week  in the second case the interval falls in two weeks      if   the first day of week  lt    the last day of week            if   the first day of week  lt   6  amp  amp  6  lt    the last day of week   no remaining days--          if   the first day of week  lt   7  amp  amp  7  lt    the last day of week   no remaining days--            else               edit by Tokes to fix an edge case where the start day was a Sunday            and the end day was NOT a Saturday              the day of the week for start is later than the day of the week for end         if   the first day of week    7                   if the start date is a Sunday  then we definitely subtract 1 day              no remaining days--               if   the last day of week    6                       if the end date is a Saturday  then we subtract another day                  no remaining days--                                  else                  the start date was a Saturday  or earlier   and the end date was  Mon  Fri                 so we skip an entire weekend and subtract 2 days              no remaining days -  2                         The no  of business days is   number of weeks between the two dates     5 working days    the remainder   ---- gt february in none leap years gave a remainder of 0 but still calculated weekends between first and last day  this is one way to fix it     workingDays    no full weeks   5      if   no remaining days  gt  0                workingDays     no remaining days               We subtract the holidays     foreach  holidays as  holiday            time stamp strtotime  holiday             If the holiday doesn t fall in weekend         if   startDate  lt    time stamp  amp  amp   time stamp  lt    endDate  amp  amp  date  N   time stamp     6  amp  amp  date  N   time stamp     7               workingDays--             return  workingDays       Example    holidays array  2008-12-25   2008-12-26   2009-01-01     echo getWorkingDays  2008-12-22   2009-01-02   holidays       gt  will return 7   gt

User · Answer

There is a Formula   number of days - math round down 10    number of days    business days in a week   days in a week      Tada  you calculate the numbers of business day  in a month  in a week  in a whatever you want   math round down    is a hypothetical method  which implements a mathematical function that rounds down

[php] Calculate business days

Examples related to php

Examples related to calendar

Examples related to date