Changing date calculation to show years

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.

Welcome, @M1114,

I’ve changed the category of your request so that you can now vote on it at the top of this thread with the purple Vote button (as I did), since this functionality is not currently available.

For a somewhat related post, see also:




Hi Larry!

Thanks so much. I’m new here so just trying to find out as much as I can.


1 Like

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.

1 Like

Or i guess just divide by 458640

1 Like