Ads

Thursday, 13 July 2017

Age

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.