> For the complete documentation index, see [llms.txt](https://help.alldrafts.com/alldrafts-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.alldrafts.com/alldrafts-documentation/fields/formula-functions/usholidays-function.md).

# USHOLIDAYS Function

**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:

   ```excel
   =WORKDAY(Project_Start_Date, 30, USHOLIDAYS())
   ```
2. To determine the number of business days between two dates, excluding weekends and US Federal Holidays:

   ```excel
   =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.