YEAR

๋‚ด๋ถ€ ๊ณ„์‚ฐ ๊ทœ์น™์— ๋”ฐ๋ผ ์—ฐ๋„๋ฅผ ์ˆซ์ž๋กœ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ

YEAR(์ˆซ์ž)

์ˆซ์ž๋Š” ๋…„๋„์ˆ˜๋ฅผ ์‚ฐ์ถœํ•  ๋‚ด๋ถ€ ๋‚ ์งœ๊ฐ’์„ ์ง€์ •ํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ

=YEAR(1)์€ 1899๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=YEAR(2)๋Š” 1900๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

=YEAR(33333.33)์€ 1991๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.