How to calculate age in formula field in salesforce

image

To create a formula field to calculate age based on a Contact birth date:

  • Go to Setup -> Customize -> Contact -> Fields.
    • In Lighting go to Setup -> Object Manager -> Contact -> Fields & Relationships.

Full
Answer

How to calculate age from another date in Salesforce?

Salesforce.com – Adding a Formula Field to Calculate Age from Another Date field 1 Enter a field label (e.g., Current Age). 2 Choose Number for the Return Type with 0 decimal places. More …

How to create a formula field to calculate a contact’s age?

To create a formula field to calculate age based on a Contact birth date: Go to Setup -> Customize -> Contact -> Fields In Lighting go to Setup -> Object Manager -> Contact -> Fields & Relationships Click New to create a custom field.

How do I calculate my child’s age?

If they have, then their age can be calculated by subtracting their birth year from the current year. If they have not yet had their birthday, then you’ll need to subtract another year from that difference.

How do I calculate the years and months in Excel?

To calculate the Years you could use: (TODAY()-Birthdate)/365.2425. example: ((11-05-2010)-(26-08-1980)/365.2425) = 29 years. And about the months, you could use a “mod” that returns a remainder after a number is divided by a specified divisor:

image


Tuesday, April 23, 2013

In Salesforce, it is easy to calculate number of day between 2 date. Just create a formula field, example: End_Date__c – Start_Date__c. DONE!!!


Salesforce: How to calculate age for weekday or weekend ?

In Salesforce, it is easy to calculate number of day between 2 date. Just create a formula field, example: End_Date__c – Start_Date__c. DONE!!!

image

Leave a Comment