Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello!
Sorry my english :) Who can tell me what's the diference between the several basis number -- HC |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
yearfrac | Excel Worksheet Functions | |||
Yearfrac problems | Excel Discussion (Misc queries) | |||
Yearfrac problem | New Users to Excel | |||
yearfrac problem | Excel Worksheet Functions | |||
yearfrac problem | Setting up and Configuration of Excel |