Year Function

DateSerial ๋˜๋Š” DateValue ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์ƒ์„ฑํ•œ ์—ฐ์† ๋‚ ์งœ ๋ฒˆํ˜ธ์—์„œ ์—ฐ๋„๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ:

Year (Number)

๋ฐ˜ํ™˜ ๊ฐ’:

Integer

๋งค๊ฐœ ๋ณ€์ˆ˜:

Number: ์—ฐ๋„๋ฅผ ๊ณ„์‚ฐํ•˜๋Š” ๋ฐ ์‚ฌ์šฉ๋˜๋Š” ์—ฐ์† ๋‚ ์งœ ๋ฒˆํ˜ธ๋ฅผ ํฌํ•จํ•˜๋Š” ์ •์ˆ˜ ์‹์ž…๋‹ˆ๋‹ค.

์ด ํ•จ์ˆ˜๋Š” DateSerial ํ•จ์ˆ˜์™€ ๋ฐ˜๋Œ€๋˜๋Š” ๊ฒƒ์œผ๋กœ, ์—ฐ์† ๋‚ ์งœ์˜ ์—ฐ๋„๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค. ์˜ˆ๋ฅผ ๋“ค์–ด,

Print Year(DateSerial(1994, 12, 20))

๊ฐ’ 1994๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

Error codes:

5 ์ž˜๋ชป๋œ ํ”„๋กœ์‹œ์ € ํ˜ธ์ถœ์ž…๋‹ˆ๋‹ค.

์˜ˆ:

Sub ExampleYear

    MsgBox "" & Year(Now) ,64,"Current year"

End Sub