YEARFRAC
The result is the number of the years (including fractional part) between StartDate and EndDate.
α‘ααα’αα₯α‘α
YEARFRAC(α‘αα¬α§αα‘α ααα αα¦α;α‘αααααα ααα αα¦α;α€α£α«α)
α‘αα¬α§αα‘α ααα αα¦α αα α‘αααααα ααα ααα: ααα αα¦αα‘ αα α αααα‘ααααααα.
α€α£α«α: ααααα α©ααα ααα αααα’α αααα‘ α‘ααααα αα αααα‘ααα¦αα ααα‘ α αααα ααααααααααα‘ α¬αααα.
α€α£α«α |
αααααααα |
0 αα αα αα αα‘ |
αα¨α¨ αααααα (NASD), 12 ααα, α§ααααα¨α 30 αα¦α |
1 |
αααααα¨α αα¦ααααα‘ αα£α‘α’α α αααααααα, α§αααα α¬ααα‘ αα¦ααααα‘ αα£α‘α’α α αααααααα |
2 |
αααα¨α αα¦ααααα‘ αα£α‘α’α α αααααααα, α¬αααα¬ααα¨α 360 αα¦αα |
3 |
αααα¨α αα¦ααααα‘ αα£α‘α’α α αααααααα, α¬αααα¬ααα¨α 365 αα¦αα |
4 |
ααα ααα£αα αααααα, 12 ααα α§ααααα¨α 30 αα¦α |
αααααααα
2001 α¬ααα‘ α α ααα¬ααα αα αα‘ 1.1.2002-α‘ αα 7.1.2001-α‘ α¨αα αα‘?
=YEARFRAC("2008-01-01"; "2008-07-01";0) returns 0.50.