Products, services, and OS functions
may not be available in this country.

YEAR

The YEAR function returns the year for a given date/time value or date string.

YEAR(date)

date: A given date/time value or date string.

Examples

=YEAR("4/6/88 11:59:22pm") returns 1988.

=YEAR(NOW()) returns the current year. For example, 2020 is returned when calculated anytime during 2020.

See alsoDAYMONTH
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.