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.


NxIsWorkDay(date, holidays, Weekends)
is the serial number that represents a given day. If missing, the current date is used.
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.
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.


  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.


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



Article is closed for comments.

Was this article helpful?
0 out of 0 found this helpful