Why do I get a #value error when doing the 360days formula?

  • Thread starter Thread starter trainer07
  • Start date Start date
T

trainer07

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.
 
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 Data>Text to Columns>Next>Next>Column Data Format.
Select a format like YMD or MDY

Click Finish.

Any joy now with your formula?


Gord Dibben MS Excel MVP
 
In addition to the other responses, also check to make sure you really want
the to use Days360.

For example, if c1 is Feb 1/09, and c2 is Mar 1/09, how many days do you
believe are between them? If the answer is the fictitious number 30, then
you want Days360. If the answer is the actual number 28, then you simply
want to subtract your dates, as in:

=c2-c1

Regards,
Fred.
 
Back
Top