days360

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

keng - 19 Mar 2008 14:59 GMT

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?

Reply to this Message

Bob I - 19 Mar 2008 15:26 GMT

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?

> Days360 is coming up a few days short. This is what I have
>
[quoted text clipped - 5 lines]
> it is giving me 642 and I believe that it should be 652
> Any suggestions?

Reply to this Message

keng - 19 Mar 2008 15:39 GMT

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

Thanks

> 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.
[quoted text clipped - 14 lines]
> > it is giving me 642 and I believe that it should be 652
> > Any suggestions?

Reply to this Message

Bob I - 19 Mar 2008 18:33 GMT

then just format the cell as General and use

=A2-A1

> I am attemting to copy a digital countdown calendar. I assumed that the 652
> days left was correct.
[quoted text clipped - 19 lines]
>>>it is giving me 642 and I believe that it should be 652
>>>Any suggestions?

Reply to this Message