YEARFRAC

The result is the number of the years (including fractional part) between StartDate and EndDate.

ꡬ문

YEARFRAC(μ‹œμž‘μΌ; μ’…λ£ŒμΌ; 원칙)

μ‹œμž‘λ‚ μ§œμ™€ λλ‚ μ§œλŠ” 각각 λ‚ μ§œ κ°’μœΌλ‘œ μž…λ ₯λ˜μ–΄μ•Ό ν•©λ‹ˆλ‹€.

밑은 ν•΄[εΉ΄]λ₯Ό μ–΄λ–€ λ°©μ‹μœΌλ‘œ 계산할지 λ‚˜νƒ€λƒ…λ‹ˆλ‹€.

기초

계산

0 λ˜λŠ” μ—†μŒ

US-방식 (NASD), 30일씩 12달

1

μ •ν™•ν•œ κ·Έ λ‹¬μ˜ 일수, μ •ν™•ν•œ κ·Έ ν•΄μ˜ 일수

2

μ •ν™•ν•œ κ·Έ λ‹¬μ˜ 일수, κ·Έ ν•΄ 360일

3

μ •ν™•ν•œ κ·Έ λ‹¬μ˜ 일수, κ·Έ ν•΄ 365일

4

유럽-방식, 30일씩 12달


예

What fraction of the year 2008 lies between 2008-01-01 and 2008-07-01?

=YEARFRAC("2008-01-01"; "2008-07-01";0)은 0.50으둜 μž…λ ₯λ©λ‹ˆλ‹€.