NxIsWorkDay - Check a given date for weekends and holidays

Examines a given date for weekends and holidays (non-working days), and returns FALSE if it falls on a non-working day; otherwise it returns TRUE.

 

Syntax

NxIsWorkDay(date, holidays, Weekends)

date is the serial number that represents a given day. If missing, the current date is used.

holidays is an array of holiday dates, holiday codes (e.g. NYD,PRS), a calendar code(e.g. US, GBP, NYMEX) or a combination of them. If missing, the U.S. government calendar is used.

Weekends is the weekend number(1-7,11-17) or a 7-character string code. If missing, the Western weekend (i.e. 1, "Saturday, Sunday") is used.

 

Remarks

  1. If the given date is not valid, NxISWORKDAY returns the #VALUE! error.
  2. If an unsupported calendar is used, NxISWORKDAY returns the #VALUE! error.
  3. If the holidays are passed as an array of dates, the default weekend is used (i.e. 1, "Saturday, Sunday").
  4. For more weekend conventions, see the Weekend category.
  5. For a full list of supported holidays, see the Holiday category.
  6. For a full list of supported calendars, see the Calendar category.
  7. Microsoft Excel stores dates 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.

Examples

Example 1: The Saudi Arabia calendar (SAU) does not celebrate the Western New Year's Day, so 01/02/2012 is a working day.



  Formula Description (Result)
  =NxIsWorkDay(DATE(2012,8,23)) TRUE
  =NxIsWorkDay(DATE(2012,5,28)) FALSE

Files Examples

References

Have more questions? Submit a request

0 Comments