Why do I get a #value error when doing the 360days formula?
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.
"trainer07" wrote in message
...
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.
|