Sign Up ›
  • Aashish Jain
  • NEWBIE
  • 0 Points
  • Member since 2016
  • 360 Degree Cloud Technology Pvt. Ltd.
  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
2 replies

age formula

Formula to calculate the Age in Years,Months, Weeks and Days


IF(
NOT( ISNULL (Date_of_Birth__c)), /* Condition */

TEXT(FLOOR((TODAY()-Date_of_Birth__c)/365.2425)) & " Years " &
TEXT(FLOOR(MOD((TODAY()-Date_of_Birth__c),365.2425)/30)) & " Months " & 
Text(Floor(MOD(Floor(MOD((TODAY()-Date_of_Birth__c),365.2425)),30)/7)) & " Weeks "  & 
 TEXT( FLOOR( MOD( FLOOR( MOD( FLOOR( MOD(TODAY()-Date_of_Birth__c,365.2425) ) ,30) ) ,7) ) ) 
& " Days" ,  
/* Value IF True */
"Check your DOB " /* Value IF False */
)
2 replies

age formula

Formula to calculate the Age in Years,Months, Weeks and Days


IF(
NOT( ISNULL (Date_of_Birth__c)), /* Condition */

TEXT(FLOOR((TODAY()-Date_of_Birth__c)/365.2425)) & " Years " &
TEXT(FLOOR(MOD((TODAY()-Date_of_Birth__c),365.2425)/30)) & " Months " & 
Text(Floor(MOD(Floor(MOD((TODAY()-Date_of_Birth__c),365.2425)),30)/7)) & " Weeks "  & 
 TEXT( FLOOR( MOD( FLOOR( MOD( FLOOR( MOD(TODAY()-Date_of_Birth__c,365.2425) ) ,30) ) ,7) ) ) 
& " Days" ,  
/* Value IF True */
"Check your DOB " /* Value IF False */
)