The Excel Workday.Intl function returns a date that is a supplied number of working days (excluding weekends and holidays) ahead of a given start date. The function allows the user to specify which days are counted as weekends.
The function is new in Excel 2010 and so is not available in earlier versions of Excel. However, it is similar to the Workday function, which is available in earlier versions of Excel.
The format of the Workday.Intl function is:
|start_date||-||The initial date, from which to count the number of workdays|
|days||-||The number of workdays to add onto start_date|
An optional argument, which specifies which weekdays should be counted as weekends. This can be either a number or a string. These are explained below:
|[holidays]||-||An optional argument, which specifies an array of dates (in addition to weekends) that are not to be counted as working days|
Note that the start_date and [holidays] arguments should be input as either:
- If you attempt to input these date arguments as text, Excel may misinterpret them, due to different date systems, or date interpretation settings.
Warning: Although you can input date arguments as date serial numbers, this is not recommended as date serial numbering does vary across different computer systems.
The spreadsheets below show examples of the Excel Workday.Intl function. The format of the function is shown in the spreadsheet at the top and the results are shown below.
In the above spreadsheets :
Note also that, as recommended by Microsoft, in all three calls to the Workday.Intl function, the start_date and [holidays] arguments have been supplied as cell references.
Further examples of the Excel Workday.Intl function can be found on the Microsoft Office website.
If you get an error from the Excel Workday.Intl function this is likely to be one of the following :
Occurs if either:
Occurs if either: