Share via

DATEDIF Excel 2013

Anonymous
2017-06-29T12:40:23+00:00

Hi

I've been googling and trying everything I can think of and still I'm jammed.

I use Excel 2013 and scandinavian dates and cannot get DATEDIF-function to work.

I've been typing =DATEDIF(D2, TODAY(),"Y")

Excel seems to recognize the first cell as part of the function, but not the second value (i've tried other cells on the place of today() too.)

It seems that my excel does not recognize this as a function. The cells containing dates are "date" formatted.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2017-06-29T13:04:05+00:00

It worked fine for me in a US English version of Excel (your exact formula).   your reference to scandinavian dates might suggest several things.

Is your list separator a comma?    Perhaps it should be a semi-colon

The names of your functions may not be the same as the US English version so the function isn't recognized.

--

Regards,

Tom Ogilvy

Was this answer helpful?

9 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-06-29T13:21:22+00:00

    You're a genius! It was the semi-colon that fixed this. ;

    =DATEDIF(A1;TODAY();"Y") (For all scandinavian people)

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments