Examines whether the given date falls on a weekend or a holiday (i.e., non-working day), and returns the nearest working business day using a Business Day Convention (BDC).
Syntax
NxAdjust (Date, Convention, Holidays, Weekends)
- Date
- is a serial date number that represents a given date. If missing, the current date is used.
- Convention
- is the Business Day Convention (BDC): 1 = Following, 2 = Following Modified, 3 = Preceding, 4 = Preceding Modified, 5 = Unadjusted (default).
Value Convention 1 Following - the following business day. 2 Following Modified - the following business day as long as this falls within the same month; otherwise the preceding business day. 3 Preceding - the preceding business day. 4 Preceding Modified - the preceding business day as long as it falls within the same month; otherwise the following business day. 5 Unadjusted - leaves the date unchanged (default). - Holidays
- is a specific calendar code, an array of holiday codes, or an array of holiday dates. If missing, the U.S. federal holidays are used.
- Weekends
- is the weekend number (1-7,11-17) or the weekend string value (7-character string). If missing, the western weekend (i.e., 1, "Saturday, Sunday") is used.
Remarks
- NxAdjust accounts for situations when a payment date falls on a weekend or holiday and calculates the corresponding value date.
- If a given date or any of the holiday/calendar codes is invalid, NxAdjust returns the #VALUE! error.
- If the business day convention (BDC) value is less than one(1) or greater than five (5), NxAdjust returns the #VALUE! error.
- For more weekend conventions and codes, see the Weekend category.
- For a full list of supported calendars and their corresponding codes, visit the Calendar category.
- Microsoft Excel stores date as sequential serial numbers so they can be used in calculations. By default, January 1, 1900, is serial number 1, and January 1, 2008, is serial number 39448 because it is 39,448 days after January 1, 1900.
Example
December 25 is considered to be a U.S. government holiday.
| Formula | Description (Result) |
|---|---|
| =NxAdjust(DATE(2012,5,27),1,"USD") | Tuesday, May 29, 2012 |
| =NxAdjust(DATE(2012,3,31),2) | Friday, March 30, 2012 |
| =NxAdjust(DATE(2012,5,27),3,"USD") | Friday, May 25, 2012 |
| =NxAdjust(DATE(2012,4,1),4) | Monday, April 02, 2012 |
| =NxAdjust(DATE(2012,4,1),5) | Sunday, April 1, 2012 |
Files Examples
Related Links
References
- Hans-Peter Deutsch, Derivatives and Internal Models, Palgrave Macmillan (2002), ISBN 0333977068.
- Satyajit Das, Swap and Derivative Financing: The Global Reference to Products, Pricing, Applications, and Markets, McGraw-Hill Companies (1993), ISBN 1557385424.
Comments
Article is closed for comments.