Need help in Data to age formula in excel

[Vikas_Salvi]

if the date 01-jan-1900 than the output must be 0 its showing 124.how to resolve the problem.'

DOB	Age	Bucket
23-Nov-89​	34​	25 - 35 Years
26-Apr-89​	34​	25 - 35 Years
11-Jan-89​	35​	25 - 35 Years
01-Jan-00​	124​	>Above 55 Years
19-May-83​	40​	36 - 45 Years
05-May-62​	61​	>Above 55 Years

 

[ETAF]

add an IF()

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

This will possibly enable a quicker and more accurate solution for you.

 

[p45cal]

=IF(B4<=1,0,DATEDIF(B4,TODAY(),"Y"))

 

[Vikas_Salvi]

=IF(B4<=1,0,DATEDIF(B4,TODAY(),"Y"))

Thank you