PC Review


Reply
 
 
keng
Guest
Posts: n/a
 
      19th Mar 2008
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 With Quote
 
 
 
 
Bob I
Guest
Posts: n/a
 
      19th Mar 2008

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?
>
>


 
Reply With Quote
 
keng
Guest
Posts: n/a
 
      19th Mar 2008
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?
> >
> >

>
>

 
Reply With Quote
 
Bob I
Guest
Posts: n/a
 
      19th Mar 2008
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?
>>>
>>>

>>
>>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
More effective than DAYS360? fgwiii Microsoft Excel Worksheet Functions 1 28th Apr 2008 03:32 PM
DAYS360 =?Utf-8?B?Q2FuZGVudGNvIENyZWF0aXZlIENvbGxlY3Rpb24= Microsoft Excel Worksheet Functions 4 12th Apr 2007 09:48 PM
Bug in days360 function Philippe_L Microsoft Excel Worksheet Functions 3 18th Apr 2006 09:14 PM
=DAYS360 =?Utf-8?B?T3dlbg==?= Microsoft Excel Misc 1 15th Feb 2006 03:30 PM
DAYS360 =?Utf-8?B?SmFuIEJ1Y2tsZXk=?= Microsoft Excel Worksheet Functions 3 21st Jul 2005 10:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:56 AM.