Skip to content
ProcessPlanProcessPlan Docs

=DATESERIAL

The =DATESERIAL() function can be used to create a date from its individual components. Useful for constructing dates dynamically in calculations, workflows, or reporting.

Syntax

Section titled “Syntax”
=DATESERIAL(Year; Month; Day)

Parameters

Section titled “Parameters”

  • Year

    • The numeric year component of the date (e.g., 2025).

  • Month

    • The numeric month component (1–12).

  • Day

    • The numeric day component (1–31, depending on the month).

How It Works

Section titled “How It Works”

  • Combines the specified year, month, and day into a valid date.

  • Supports numeric inputs and can be used in further date calculations or formulas.

Usage Notes

Section titled “Usage Notes”

  • Ensure numeric values are valid for the calendar (e.g., no February 30).

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

Example

Section titled “Example”
=DATESERIAL(2025; 6; 15)
// Returns: 2025-06-15

Keywords

Section titled “Keywords”

DATESERIAL, create date, construct date, year month day, date calculation, workflow formulas, dynamic date, formula function, process field dates