registered date - current date

[villival]

Hi Guys
need to know age of Registration date with current date
i am looking for fromuala to calculate current date - registration date

i have registration date
11/12/2014 11:26
Current date
03/08/2016

how to find the age

Thanks

 

[Naresh Yadav]

Dear Villival,

pls convert your Registration date as per as your Current date with the given formula and than substract your current date with registation date
here is the attached file for your better understand
=DATE(MID(A2,FIND("/",A2,FIND("/",A2)+1)+1,4),MID(A2,FIND("/",A2)+1,2),LEFT(A2,2))

regards
Naresh

 

[bosco_yip]

1] A2, enter : Registration date

2] B2, enter : Current date

3] In the age C2, enter formula :

=DATEDIF(A2,B2,"y")

or,

=DATEDIF(A2,TODAY(),"y")

Regards
Bosco

 

[Asheesh]

DATEDIF could be an option...