YEAR function

From Apache OpenOffice Wiki
Jump to: navigation, search
< {{#switch:Previous Section Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} {{#switch:Next Section Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} >
< {{#switch:Previous Page Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} {{#switch:Next Page Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} >



YEAR

Returns the year of a given date.

Syntax:

YEAR(date)

returns the year of date as a number.
date may be text or a date-time serial number.

Example:

YEAR("2008-06-04")

returns 2008.

YEAR(A1)

where cell A1 contains the date 23Nov83 as a date-time serial number, returns 1983.



{{#switch:EN

| RU = Смотрите также: | UA = Дивіться також: | EN = See Also | PT = Ver também | #default = See Also }}

Personal tools