YEARFRAC FORMULA

Lets Start Again..

“YEARFRAC” formula is used to count assets aging in certain periode.
The Formula : “=YEARFRAC(START DATE,END DATE)” ----> a

E.g :

1. a buidling built on October 01,1980, then on October 01,2008 management want to know how old the building is, so u can find it by this following :



2. And how old the building on September 01,2008?
- If u use above mentioned formula, the result will be in decimal 27.91666


so how can we make it not to be in decimal?
-we can make it by adding “=ROUND()” before the formula.
to be : “=ROUND(YEARFRAC(START DATE,END DATE),0)” ----> b
This formula will make the up-rounding or down-rounding, based on our needs.
okey,.we try as per below :

It's easy, right?

3. The problem is how we know how old the building, counted in months, on September 01,2008.
So we count it by multiplying 12 months ( x 12 ) above formula ( b )
to be : “=ROUND(YEARFRAC(START DATE,END DATE)*12,0)” ---> c


4. We can also find the age, counted in days, on September 01,2008.
by multiplying 365 days ( x 365 ) above formula ( b )
to be : “=ROUND(YEARFRAC(START DATE,END DATE)*365,0)” ---> d


warm regards