YEAR ()
This
function extracts the year number from a date.
Best view in desktop mode.
A
|
B
|
C
|
D
|
|
1
|
Date
|
Year
|
||
2
|
Monday, December 23, 2019
|
2019
|
=YEAR(A2)
|
|
3
|
10/22/2018
|
2018
|
=YEAR(A3)
|
|
4
|
8-May-92
|
1992
|
=YEAR(A3)
|
|
5
|
Syntax
=YEAR(date)
=YEAR(serial_number)
Formatting
No special
formatting needed. The result is shown as a number in 4 digit.
No comments:
Post a Comment