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

[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.

 

[Max]

Recheck your data in C1:C2 that these are real dates recognized by Excel
Probably C1 &/or C2 contains text
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik

 

[Gord Dibben]

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

 

[Fred Smith]

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.