Forum Discussion
how to calculate age in excel
hii everyone, im learning excel from youtube tutorial which uses datedif to calculate age but im not getting that option in my excel. any help would be appreciable. thank you
As it stands, your formula works fine. It is
= INT(YEARFRAC(A1:A10, B1))that becomes a problem. I have been caught out a number of times by this generation of time functions that appear to be perfectly formed but fail given multi-cell range references.
Got it. Hence your reference to an array!