• Settlement (required): The settlement date of the security. It is the date after the issue date when the security is purchased;
• Maturity (required): The maturity date of the security. It is the date on which the security expires;
• Issue (required): The issue date of the security;
• Rate (require): The interest rate of the security on the date of issue;
• Pr (required): The security’s price per $100 face value;
• Basis (optional): An integer number (0, 1, 2, 3 or 4) specifying the day basis to be used. Default is 0.

Basis	Date System
o or omitted	US (NASD) 30/360
1	Actual/actual
2	Actual/360
3	Actual/365
4	European 30/360

1. In Excel, dates can be used in calculations as they are stored as sequential numbers. By default, 1/1/1900 is serial number 1, so 12/1/2021 is serial number 40877 because it is 40876 days after 1/1/1900;

2. Dates provided for “settlement” and “maturity” should be entered:

3. If settlement, maturity, issue, and basis contain decimal, they will be truncated to integers;

4. The #NUM! error occurs when any of the following conditions is met:

5. The #VALUE! error occurs when either of the following conditions is met:

2.2 In the Format Cells dialog box, under the Number tab, select Percentage in the Category list box, specify the Decimal places and finally click the OK button to save the changes.