Changing date calculation to show years

[M1114]

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.

[lpb]

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:

Introducing Formula Custom Fields!

It’s good to see that when creating a formula for (due date) minus (start date) the value is in days (and hours if a start/end time is added). However, for a task that runs for a week, Monday to Friday, for example 3rd July until 7th July (5 days), the value unfortunately returns as 4 days. All the values from the formula are 1 day less which in turn provides an inaccurate SUM (albeit in weeks & days instead of just days). So a task that is to be completed in a day, returns a blank value, inste…

Thanks,

Larry

[M1114]

Hi Larry!

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

M