Diru beehaache
The result is the number of the years (including fractional part) between StartDate and EndDate.
Ganallo
YEARFRAC(StartDate; EndDate; Xinta)
StartDate nna EndDate lame barru hornyuwaati.
Xinta doorshubbate dirtonni dooraminoho nna diru hiittoonni shallagamannoro leellishanno.
|
Xinta |
Shallaggo |
|
0 woy hawama |
US metede (NASD), 12 aganna mittu mittunku 30 barruwa afirino |
|
1 |
Agannate giddo barruwa halaalanya kiiro, dirrate giddo barruwa halaalanya kiiro |
|
2 |
Agannate giddo barruwa halaalanya kiiro, diru 360 barruwa afirino |
|
3 |
Agannate giddo barruwa halaalanya kiiro, diru 365 barruwa afirino |
|
4 |
Awurooppu metede, 12 aganna mittu mittunku 30 barruwa afirino |
Lawishsha
Diru 2008 2008-01-01 nna 2008-07-01 may beehaachi meereero uwanno?
=YEARFRAC("2008-01-01"; "2008-07-01";0) 0.50 qolanno.