Salesforce formula that calculates age

Introduction

If you need a quick Salesforce formula to calculate the age of a person based on their birthdate or another value, here is one.

Formula

FLOOR(((DATEVALUE(TODAY__C))-(BIRTHDATE__C))/365)

Where

TODAY__C

represents today’s date and

BIRTHDATE__C

represents the birthdate you are trying to figure out.