What is wrong with this to find the difference in years between two dates?

(MONTHS(Today;Purchased))/12

I’ve also tried = MONTHS(Today;Purchased)/12

All I get is = Dec 31, 1969 at 3:59:54 PM

The field for the # of years is decimal style with 2 decimal places.

Hi Glen,

Did you try the `YEARS(TODAY(); Purchased)`

function instead?

That’ll give you the number of years between those two dates.

Also `TODAY()`

is a function, so you need the `()`

.

That wasn’t on the list to select from.

Tried it and get a date as result. = Dec 31, 1969 at 3:59:50 PM

field is calculated

type is Decimal

Is there another setting someplace?

###### Attachments:

You must be

logged in to view attached files.

It was in the list of functions on the right on the Formula Edit screen.

In any case, you have your Result Type set to return a Date value, but the `YEARS()`

function actually returns a Number type.

Thanks. That setting gets me every time.

But, why is the result look at a quick glance, but why are all the values negative? ie: -4.

My numbers for age in months is positive, but these are all negative.

AH, position matters. I got it…

Thanks.

You could also add ABS() around your function to get the absolute value, which will always return a positive number.

`ABS(X) returns the absolute value. e.g. ABS(4) = 4 and ABS(-4) = 4.`