USHOLIDAYS Function
Purpose: The USHOLIDAYS()
function returns an array of dates representing the US Federal Holidays from the years 2020 through 2038.
Syntax:
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:
To exclude US Federal Holidays when calculating the end date of a project that is expected to take 30 business days:
To determine the number of business days between two dates, excluding weekends and US Federal Holidays:
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.
Last updated