#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default yearfrac

Hello!
Sorry my english :)
Who can tell me what's the diference between the several basis number
--
HC
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default yearfrac

I'm sorry, but can you try again? I don't understand what you want.

Pete

On Sep 2, 4:43*pm, lena_form
wrote:
Hello!
Sorry my english :)
Who can tell me what's the diference between the several basis number
--
HC


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default yearfrac

Basis 0 = NASD number of days in range / 360
Basis 1 = actual number of days in range / actual number of days in year
(365 or 366)
Basis 2 = actual number of days in range / 360
Basis 3 = actual number of days in range / 365
Basis 4 = European number of days in range / 360

Basis 0 and 4 really = number of months in range / 12. If you have a whole
month in the range (ie from the 1st of one month to the 1st of the next),
you will always get a Yearfrac of 0.083333 (ie, 1/12), regardless of the
number of days in the month. For periods of less than one month, Basis 0 and
4 = Basis 2.

Basis 0 and 4 differ in determining how long a month is. Under Basis 0, one
month is 30 days, so from Jan 1 to Jan 31 is a full month, therefore a
Yearfrac of 0.083333. Under Basis 4, one month is a full calendar month, so
Jan 1 to Jan 31 is .080556.

Regards,
Fred.


"lena_form" wrote in message
...
Hello!
Sorry my english :)
Who can tell me what's the diference between the several basis number
--
HC


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
yearfrac slymeat Excel Worksheet Functions 2 September 23rd 05 09:31 PM
Yearfrac problems Adriana Excel Discussion (Misc queries) 1 July 28th 05 11:55 AM
Yearfrac problem Adriana New Users to Excel 1 July 28th 05 10:18 AM
yearfrac problem Adriana Excel Worksheet Functions 0 July 28th 05 08:04 AM
yearfrac problem Adriana Setting up and Configuration of Excel 0 July 28th 05 08:03 AM


All times are GMT +1. The time now is 10:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"