---
title: Flag holidays
description: Identify holidays, weekends, and weekdays based on a date column.
category: Data Transforms
tags: [date, holidays, weekend, flag]
---

# Flag holidays

## Description

The **Flag Holidays** activity scans a date column and flags each row as a **Holiday**, **Weekend**, or **Weekday**. It supports both Infoveave’s predefined holiday calendars and custom holiday lists. You can also define which days of the week are considered weekends.

> **Use Case**  
> Automatically tag dates in a sales or attendance log as working days, weekends, or public holidays. This is useful for time-series analysis, attendance automation, or business day filtering.

---

## Input

| Type | Description                            |
| ---- | -------------------------------------- |
| Data | Dataset with at least one date column. |

---

## Output

| Type             | Description                                             |
| ---------------- | ------------------------------------------------------- |
| Transformed Data | Data with an additional column indicating the day type. |

---

## Configuration Fields

| Field Name                 | Required | Description                                                            |
| -------------------------- | -------- | ---------------------------------------------------------------------- |
| **Date column**            | Yes      | The column containing dates to check against holidays/weekends.        |
| **Weekly off days**        | No       | List of days considered weekends (e.g., Saturday, Sunday).             |
| **Output column**          | Yes      | Name of the output column for flags (`Holiday`, `Weekend`, `Weekday`). |
| **Include original**       | No       | If enabled, retains original input columns in output.                  |
| **Use Infoveave holidays** | No       | If enabled, uses Infoveave’s predefined holiday list.                  |
| **Custom holidays**        | No       | Allows adding user-defined holidays with name and date.                |

---

## Sample Input

| event_date |
| ---------- |
| 2025-01-01 |
| 2025-08-15 |
| 2025-09-21 |
| 2025-09-23 |
| 2025-09-24 |

---

## Sample Configuration

| Field                  | Value                                                                         |
| ---------------------- | ----------------------------------------------------------------------------- |
| Date column            | `event_date`                                                                  |
| Weekly off days        | `Saturday`, `Sunday`                                                          |
| Output column          | `flag`                                                                        |
| Include original       | Enabled                                                                       |
| Use Infoveave holidays | Enabled                                                                       |
| Custom holidays        | <ul><li>New Year – 2025-01-01</li><li>Independence Day – 2025-08-15</li></ul> |

<!-- ![alt text](flag-holidays-img.png) -->

---

## Sample Output

| event_date | flag    |
| ---------- | ------- |
| 2025-01-01 | Holiday |
| 2025-08-15 | Holiday |
| 2025-09-21 | Weekend |
| 2025-09-23 | Weekday |
| 2025-09-24 | Weekday |

---

> You can use this activity before time-based aggregations or joins to exclude weekends and holidays from calculations.