Skip to content
ProcessPlanProcessPlan Docs

=DATELIST

The =DATELIST function generates a semicolon-separated list of consecutive dates between two specified dates. The function includes both the start date and end date in the returned list, making it useful for creating date ranges for reporting, scheduling, and data analysis purposes.

Syntax

Section titled “Syntax”
=DATELIST(StartDate; EndDate)

Parameters

Section titled “Parameters”

  • StartDate

    • The beginning date of the range.

    • Must be a valid date (YYYY-MM-DD format recommended).

    • Must be earlier than or equal to EndDate.

    • Included as the first item in the returned list.

  • EndDate

    • The ending date of the range.

    • Must be a valid date (YYYY-MM-DD format recommended).

    • Must be later than or equal to StartDate.

    • Included as the last item in the returned list.

How It Works

Section titled “How It Works”

  • Generates all consecutive dates from StartDate to EndDate, inclusive.

  • Dates are returned as a semicolon-separated string.

  • Handles month-end, quarter-end, year-end, and leap years correctly.

  • Only the date portion is returned; time components are not included.

Usage Notes

Section titled “Usage Notes”

  • Ensure dates are in YYYY-MM-DD format for proper recognition.

  • Large date ranges may create long strings; consider performance.

  • Semicolons separate dates in the returned string.

  • Supports ranges within a month, across months, quarters, and years.

  • Formula functions are case sensitive and must be in all caps.

Examples

Section titled “Examples”

Basic Usage

Section titled “Basic Usage”
// Generate a simple 5-day date range
=DATELIST(2025-06-01; 2025-06-05)
// Returns: 2025-06-01;2025-06-02;2025-06-03;2025-06-04;2025-06-05


// Single day range (start and end date are the same)
=DATELIST(2025-07-15; 2025-07-15)
// Returns: 2025-07-15


// Weekend date range
=DATELIST(2025-06-28; 2025-06-29)
// Returns: 2025-06-28;2025-06-29

Cross-Month Date Ranges

Section titled “Cross-Month Date Ranges”
// Spanning across month boundary
=DATELIST(2025-04-29; 2025-05-03)
// Returns: 2025-04-29;2025-04-30;2025-05-01;2025-05-02;2025-05-03


// Quarter end to quarter start
=DATELIST(2025-03-30; 2025-04-02)
// Returns: 2025-03-30;2025-03-31;2025-04-01;2025-04-02


// Year boundary crossing
=DATELIST(2024-12-30; 2025-01-02)
// Returns: 2024-12-30;2024-12-31;2025-01-01;2025-01-02

Common Use Cases

Section titled “Common Use Cases”

  • Report generation: Creating date ranges for daily, weekly, or monthly reports

  • Calendar creation: Generating consecutive dates for calendar applications

  • Project scheduling: Defining project timelines and milestone tracking periods

  • Data analysis: Creating date sequences for time-series analysis

  • Event planning: Scheduling multi-day events, campaigns, or activities

  • Vacation tracking: Managing employee leave and availability periods

  • Billing cycles: Generating date ranges for recurring billing or subscription periods

  • Inventory tracking: Creating date sequences for daily inventory counts

  • Performance monitoring: Setting up date ranges for system or business performance tracking

Keywords

Section titled “Keywords”

DATELIST, date range, consecutive dates, date sequence, calendar generation, project scheduling, reporting, time-series analysis, workflow formulas, process field dates, event planning, billing cycles, inventory tracking