DATEDIF(D9,E9,"d") does not work

Question

Can anybody give me a clue why I can not make it work.

I need it to work to calculate days between to dates,

and I have many, many dats to calculate.

The function is typed exactly as the book sais!!!

Ole

Answer 1

Hi,

How about =E9-D9

Does this work?

Answer 2

DATEDIF is - for unknown reasons - the black sheep of the Excel functions family. It was completely undocumented in most versions of Excel, and the name wasn't translated into other languages...

Answer 3

1. I assume that you did have an = before DATEDIF: =DATEDIF(D9,E9,"d")
2. Make sure that the date in D9 is not later than that in E9. DATEDIF does not return negative differences.
3. If your system uses comma as decimal separator, you should use semicolon between the arguments in a formula:

=DATEDIF(D9;E9;"d")

Answer 4

=E9-D9 I used before, but this time I wanted to use the other function MS provides.

I think MS should not provde something which does not work at all.

I would like to have an explenation from MS about this.

How do I get that?

Thank you for your effort.

Ole

Answer 5

In my input I forgot to typ = before the formula, but I did do it when I tryed to use it.

I have now tryed with semicolon, it does not work.

I have made shure that the dates are used in the correct order. Doesn't work.

I think it is very bad that Microsoft has such a bad explanation of the use of this function when one looks it up under Help!

AT least they should have shown examples whith figurs put into the function.

They also should go through the explanation and correct it immediately.

Mind you, this explanation I looked at was in norwegian.

Thanks for you effort.

Ole