Just because the dates are formatted as date does not necessarily mean they
are valid dates.

In an adjacent cell enter =ISNUMBER(C1)

Do you get TRUE or FALSE?

If FALSE, try this.

Select C1 and C2 then DataText to ColumnsNextNextColumn Data Format.
Select a format like YMD or MDY

Click Finish.

Any joy now with your formula?


Gord Dibben MS Excel MVP

On Tue, 13 Jan 2009 16:11:01 -0800, trainer07
wrote:

I am trying to find the number of days between two dates, but when I create
the formula, I receive a #value error message in the cell. Both cells that
have the dates in them are formatted as date. Here is how I wrote the
formula:

=days360(C1,C2)

Any assistance would be appreciated.