Hi,
let' say your dates are in column A and B, in another two columns enter

=trim(A1)
=trim(B1)

that will ride off any blank space

"Paula" wrote:

Hi Eduardo

When I drag my formula it works sometimes and not others, how can I find out
what the error is? I don't have any spaces?

Regards

Paula


"Eduardo" wrote:

Hi Paula,
check if you don't have any spaces, simple formula should work =B1-A1

"Paula" wrote:

Hi,

I am trying to calculate the number of days between 2 dates, I am sure in
the past I have simply just did a formula to say date in cell 1 - date in
cell 2, however I get a value error. The dates are formatted i nthe following
way 18/11/2009 for example and I just need to calculate the number of days
between 2 dates.

Many thanks
Paula