How to Use the SEQUENCE and DATE Functions in Google Sheets to Generate Dynamic Date Series

Generating sequential lists of dates—such as annual calendars, daily attendance trackers, bi-weekly payroll schedules, or project sprint timelines—is a foundational task in Google Sheets. Traditionally, users typed starting dates into the first few cells and manually dragged the blue fill handle down dozens or hundreds of rows. While simple, manual dragging is brittle: expanding a schedule requires repeated manual copying, changing a project start date forces you to re-drag the entire series, and inserted rows break continuity. By combining the modern dynamic array function SEQUENCE with the DATE function, Google Sheets allows you to generate entirely automated date series using a single, dynamic formula.

Understanding the Syntax of the SEQUENCE Function

The SEQUENCE function generates an array of sequential numbers arranged in rows and columns.

Formula Syntax

SEQUENCE(rows, [columns], [start], [step])

The arguments operate as follows:

• rows: The total number of rows to generate (e.g. 30 for 30 days, or 365 for a full year).
• [columns] (Optional): The number of columns to span. Defaults to 1.
• [start] (Optional): The starting value. In spreadsheet serial date math, dates are simply integers where day 1 is 31 December 1899. Supplying a date function defines the starting day.
• [step] (Optional): The increment between each sequential value. Defaults to 1 (daily). Setting 7 creates weekly intervals.

1. Generating a Continuous Daily Date Series

Suppose you want to generate a 30-day date series starting on 1 November 2026 in column A:

=SEQUENCE(30, 1, DATE(2026, 11, 1), 1)

Press Enter. Google Sheets instantly spills all 30 dates down cells A1:A30. If cells display numeric integers (e.g. 46327), select the column and format as a date via Format > Number > Date.

Making the Series Dynamic Based on a Cell Input

If your project start date is entered into cell C1 (e.g. 2026-10-01) and total duration in days is entered into cell C2 (e.g. 45):

=SEQUENCE(C2, 1, C1, 1)

Whenever you update the start date or duration in the control cells, the entire calendar expands or contracts dynamically.

2. Generating Weekly Schedules (e.g. Every Monday)

To produce weekly sprint timelines or recurring meeting logs, set the step argument to 7:

=SEQUENCE(12, 1, DATE(2026, 1, 5), 7)

This single formula generates a 12-week schedule with dates incrementing exactly seven days per row.

3. Generating Working Days Only (Excluding Weekends)

When compiling payroll or office attendance trackers, weekends must often be omitted. While SEQUENCE generates raw numbers, combining it with WORKDAY creates a dynamic business day calendar:

Suppose cell A1 holds your start date. In cell A2, enter:

=WORKDAY(A1, SEQUENCE(20, 1, 1, 1))

The formula generates 20 consecutive business days, skipping Saturdays and Sundays automatically.

4. Generating a Full Month Dynamic Grid (7×5 Calendar Grid)

You can even construct a visual multi-column wall calendar using the columns argument:

=SEQUENCE(5, 7, DATE(2026, 11, 1), 1)

This generates a 5-row by 7-column grid representing days across weeks (Sunday through Saturday).

Key Advantages Over Manual Dragging

Feature	Manual Fill Handle	SEQUENCE + DATE
Formula Overhead	Formulas duplicated in every cell	One single formula in the top cell
Adaptability	Requires manual re-dragging on changes	Instantly updates when parameters change
Sheet Performance	Heavier workbook metadata	Extremely lightweight cloud array evaluation

Leveraging SEQUENCE and DATE streamlines project planning, financial schedules, and timeline modelling across Google Sheets.