5 Replies Latest reply on Jun 6, 2014 12:57 PM by Prashant Sharma

    Date difference for DOB

    praveen p

      Hi All,


      I am trying to calculate age and facing some issues


      DATEDIFF( ‘year’, [Date of Birth], TODAY())


      However when I see the results they are getting rounded


      Example: when the users age is 28years1month its showing as 28 years same when we have difference in days


      so I am trying to get exact age with years month and days


      May be something like this in Excel I believe which I found online


      =DATEDIF (E1, TODAY( ),"Y") & " Years, " & DATEDIF (E1, TODAY( ),"YM") &

      " Months, " & DATEDIF (E1, TODAY( ),"MD") & " Days"


      Can some please help ASAP