year

Previous chapterNext chapter Show allShow all    Hide allHide all

The function year (date) calculates the year from a date value.

Syntax: =year(date)

Result format: integer

Example Example

=now() with format string hh:mm:ss dd/mm/yy is 12:46:24 05.06.01
Cell A2= day(A1) is 2001