Forum Discussion

Copper Contributor

Oct 04, 2019

Date

I want to calculate someone's age using their DOB and current time and date. =(YEAR(NOW())-YEAR(C150)) this formula does not take into account the current time or day. 23/11/2013 is returning age...

Formulas and Functions

SergeiBaklan

Diamond Contributor

Oct 04, 2019

dre0954

By the way, DATEDIF() is documented - https://support.office.com/en-us/article/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c

Another way is

=YEARFRAC(A1,TODAY(),3)

and INT() it if only full years are required

Takmil

Brass Contributor

Oct 04, 2019

I know that. What I meant was that it is undocumented inside the application.