> 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.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://help.alldrafts.com/alldrafts-documentation/fields/formula-functions/usholidays-function.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.