Days360 is coming up a few days short. This is what I have

A
1 today()
2 1/1/2010
3 =days360(a1,a2)

it is giving me 642 and I believe that it should be 652
Any suggestions?

Returns the number of days between two dates based on a 360-day year
(twelve 30-day months), which is used in some accounting calculations.
Use this function to help compute payments if your accounting system is
based on twelve 30-day months

21months*30days+12days=642

How did you get 652?

keng wrote:

> Days360 is coming up a few days short. This is what I have
>
> A
> 1 today()
> 2 1/1/2010
> 3 =days360(a1,a2)
>
> it is giving me 642 and I believe that it should be 652
> Any suggestions?
>
>

I am attemting to copy a digital countdown calendar. I assumed that the 652
days left was correct.

Thanks

"Bob I" wrote:

>
> Returns the number of days between two dates based on a 360-day year
> (twelve 30-day months), which is used in some accounting calculations.
> Use this function to help compute payments if your accounting system is
> based on twelve 30-day months
>
> 21months*30days+12days=642
>
> How did you get 652?
>
> keng wrote:
>
> > Days360 is coming up a few days short. This is what I have
> >
> > A
> > 1 today()
> > 2 1/1/2010
> > 3 =days360(a1,a2)
> >
> > it is giving me 642 and I believe that it should be 652
> > Any suggestions?
> >
> >
>
>

then just format the cell as General and use

=A2-A1



keng wrote:

> I am attemting to copy a digital countdown calendar. I assumed that the 652
> days left was correct.
>
> Thanks
>
> "Bob I" wrote:
>
>
>>Returns the number of days between two dates based on a 360-day year
>>(twelve 30-day months), which is used in some accounting calculations.
>>Use this function to help compute payments if your accounting system is
>>based on twelve 30-day months
>>
>>21months*30days+12days=642
>>
>>How did you get 652?
>>
>>keng wrote:
>>
>>
>>>Days360 is coming up a few days short. This is what I have
>>>
>>> A
>>>1 today()
>>>2 1/1/2010
>>>3 =days360(a1,a2)
>>>
>>>it is giving me 642 and I believe that it should be 652
>>>Any suggestions?
>>>
>>>
>>
>>