| | | This function is only available if you have the Analysis ToolPak add-in installed. |
| | | The security settlement date is the date after the issue date when the treasury bill is traded to the buyer. |
| | | The maturity date is the date when the treasury bill expires. |
| | | If "settlement" is not an integer, it is truncated. |
| | | If "settlement" is not a valid date, then #NUM! is returned. |
| | | If "settlement" > "maturity" , then #NUM! is returned. |
| | | If "maturity" is more than one year after "settlement", then #NUM! is returned. |
| | | If "maturity" is not an integer, it is truncated. |
| | | If "maturity" is not a valid date, then #NUM! is returned. |
| | | If "discount" = 0, then #NUM! is returned. |
