Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Date and Time > WORKDAY
 

WORKDAY(start_date, days, holidays)

 
 Returns the serial number before or after a given number of days from a given date.

 start_dateThe starting date.
 daysThe number of nonweekend and nonholiday days before or after "start_date".
 holidaysThe dates to exclude from the working calendar, holidays and floating days.

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• This function excludes weekends and any other dates specified in the "holidays" array.
     
  		• If "start_date" is not a valid date, then #VALUE! is returned.
     
  		• If "start_date" plus "days" yields an invalid date, then #NUM! is returned.
     
  		• If "days" is not an integer, it is truncated.
     
  		• If "days" > 0, then a future date is returned.
     
  		• If "days" < 0, then a past date is returned.
     
  		• If "holidays" has more than one date, you can either use an array constant or refer to a cell range.
     
  		• If "holidays" contains an invalid date, then #VALUE! is returned.
     
  		• The list can be either a range of cells that contain the dates or an array constant of the serial numbers that represent the dates.
     
  		• WORKDAY6() - Returns the serial number before or after a given number of days from a start date assuming a 6-day working week.
     
  		• WORKDAYSMISC() - Returns the serial number before or after a given number of days from a start date using a defined list of workdays.

     EXAMPLES
     
     AB
    1=WORKDAY("02/01/2000",0) = 2-Jan-0003/01/2000
    2=WORKDAY("02/01/2000",1) = 3-Jan-0004/01/2000
    3=WORKDAY("02/01/2000",5) = 7-Jan-0005/01/2000
    4=WORKDAY("02/01/2000",1,"03/01/2000") = 4-Jan-00 
    5=WORKDAY("02/01/2000",2,"03/01/2000") = 5-Jan-00 
    6=WORKDAY("02/01/2000",2,B1:B3) = 7-Jan-00 
    7=WORKDAY("02/01/2000",2,{"03/01/2000","04/01/2000"}) = 6-Jan-00 
    8=WORKDAY("01/01/1977",7,2) = 11-Jan-77 
    9=WORKDAY(1/1/1977,7,2) = 10-Jan-00 
    10=WORKDAY(DATE(1977,1,1),7,2) = 11-Jan-77 
    11=WORKDAY(DATEVALUE("01/03/1998"),5) = March 6, 1998 
    12=WORKDAY("01/02/2000",-10000000) = #NUM! 
    13=WORKDAY("30/02/2000",2) = #VALUE! 
    14=WORKDAY("02/01/2000",2,"30/02/2000") = #VALUE! 
    		 
     Functions - W | Index - W | Dates & Times | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top