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.