Excel formula help please

Gers

double_dutchy said:

In that last example #NUM! is the expected answer because A1 is blank, what do you get using this version?

=DATEDIF(A2,B2,"d")

🫢 Thanks, that worked. 

Gers

Heedtheadvice said:

Yes that formula is in error.

You did not do a side replacement so really nothing there has been has been gained

Maybe correct the formula?

"Interesting and odd! Looks like Word and Excel have different formats for the quotation marks.  "

yes interesting but not particularly relevant as you did not copy from Word into Excel but merely typed into Excel did you not?

A couple of posters had earlier suggested that the difference in the formatting of the quotation marks may have been relevant, so I experimented.

Heedtheadvice

Tee hee....that fooled me!

Great you have solved the problem.