Is it possible to change the format of a formula field to be in years? I have a formula calculating the difference between two dates (date of birth and today) to show someone’s age, however the calculation is defaulting to the amount of weeks between the two dates.

I got it. Use a formula custom field to calculate whatever you want. It will yield the number you don’t want. Then create a 2nd NEW formula custom field, and use the format in the picture. Hide the first custom field column, just show this 2nd one. You need both for it to work though. [Screen Shot…

Changing date calculation to show years

English Forum Product Feedback

Nazar_Trokhymchuk 6 April 2025 15:51 7

There is one solution: Number of years Based on a date - #2 by lpb

1 Like

Topic		Replies	Views
Formula Field not working without Start date Product Feedback startdate , date , formulas	1	796	20 November 2023
Requesting "Today" functionality in formulas; Want to Calculate Ageing; The formula I want to use is: Today(Date) - Creation(Date) Features Launched launched	13	2333	28 June 2024
For date formulas, don't stop at "weeks" as the largest value output (time delineation) Product Feedback date , formulas , date-span , duration	1	578	11 March 2024
Number Chart Format Tips and Tricks	2	51	5 September 2024
How to get current day date in a field to calculate aging Product Feedback	2	563	19 December 2023

Changing date calculation to show years

Related topics