Purpose: The USHOLIDAYS() function returns an array of dates representing the US Federal Holidays from the years 2020 through 2038.

Syntax:

USHOLIDAYS()

Arguments:

  • None.

Returns: An array of dates for the US Federal Holidays between 2020 and 2038.

Details: USHOLIDAYS() includes the following holidays:

  • New Year's Day: January 1
  • Martin Luther King Jr. Day: The 3rd Monday in January
  • President's Day: The 3rd Monday in February
  • Memorial Day: The last Monday in May
  • Juneteenth: June 19
  • Independence Day: July 4
  • Labor Day: The 1st Monday in September
  • Columbus Day: The 2nd Monday in October
  • Veteran's Day: November 11
  • Thanksgiving Day: The 4th Thursday in November
  • Christmas Day: December 25

Observance Rules:

  • For holidays that fall on a Saturday, they will be observed on the preceding Friday.
  • For holidays that fall on a Sunday, they will be observed on the following Monday.
  • USHOLIDAYS() does not account for Inauguration Day, which occurs every four years.

Compatibility: The USHOLIDAYS() function is designed for compatibility with other functions like WORKDAY() and NETWORKDAYS(), allowing users to exclude US Federal Holidays from calculations involving business days.

Examples:

  1. To exclude US Federal Holidays when calculating the end date of a project that is expected to take 30 business days:

    =WORKDAY(Project_Start_Date, 30, USHOLIDAYS())

  2. To determine the number of business days between two dates, excluding weekends and US Federal Holidays:

    =NETWORKDAYS(Start_Date, End_Date, USHOLIDAYS())

Note: The USHOLIDAYS() function ensures you consider US Federal Holidays when calculating business days. However, it is essential to double-check and verify the dates, especially in contexts where precise date calculations are crucial.