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μΌλ‘ μ λ ₯λ©λλ€.