Formualizer Docs
ReferenceFunctionsDate & Time Functions

YEAR

Extracts the calendar year from a date serial.

Summary

Extracts the calendar year from a date serial.

Remarks

  • Fractional time is ignored; only the integer date portion is used.
  • Input serials are interpreted with Excel 1900 date semantics.
  • Results are Gregorian calendar years.

Examples

Extract year from date serial
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2023
Extract year from datetime serial
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
2024

FAQ

Does YEAR use the fractional time part of a serial?

No. YEAR resolves the calendar date and ignores time-of-day fractions.

Runtime metadata

Category

Date & Time

Signature

YEAR(arg1: Number)

Arity

min 1, max 1

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/datetime/date_parts.rs

WORKDAY

WORKDAY: Returns the date serial that is a given number of weekdays from a start date.

YEARFRAC

YEARFRAC: Returns the fraction of a year between two dates for a selected day-count basis.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes YEAR use the fractional time part of a serial?Runtime metadata