days360

[keng]

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?

 

[Bob I]

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]

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

Thanks

 

[Bob I]

then just format the cell as General and use

=A2-A1