This formula will you to find age of a person or in reporting area to find age of an asset, liability, deposits &...
=INT(YEARFRAC(StartDate,TODAY()))
Int()= Int is a formula to roundoff the number to the lower side.
Yearfrac()= Yearfrac is a formula to calculate difference in years from StartDate to EndDate.
Today()= Today is a formula to get today's date which is used in this formula as end date, so that we can get age uptil today.
=INT(YEARFRAC(StartDate,TODAY()))
Int()= Int is a formula to roundoff the number to the lower side.
Yearfrac()= Yearfrac is a formula to calculate difference in years from StartDate to EndDate.
Today()= Today is a formula to get today's date which is used in this formula as end date, so that we can get age uptil today.