Calculating the difference between two dates

Question

Hello, i'm trying to do a simple calculation of the difference in days between two dates using (DATEDIF9N3,O3,''d'') However, this is not being recognised as a formula and I don't understand why. I keep getting a message saying there's a problem with the formula.

Alternatively, i'd like to use an IF formula so that if one date is greater than the other, 'deadline missed' is inserted. However, when I tried that standard formula it wouldn't recognise it either.

Many thanks

Answer 1

=IF(O3<N3,"Missed",DATEDIF(N3,O3,"D"))

Answer 2

Hi Briony,

=DATEDIF(N3,O3,"d")

should work.

But you don't need DATEDIF.

=O3-N3

works too.

Claus

Answer 3

Thanks so much. That's done the trick.

Regards

Answer 4

Thanks. I can't believe I forgot that simple way! Since I have you here, can you tell me how to do the formula to show that if column N is greater (a later date) than column O to put 'missed' in the column?

thanks

Answer 5

=DATEDIF(N3,O3,"D")

It caused by you are using two ' instead of "