days360
 

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?

days360
 

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?

days360
 

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?

days360
 

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?