Investing - Theory, News & General • Sorting Treasuries in Excel

Downloaded positions from these brokerages are in different forms.
In order to sort Treasuries by maturity date, I have been using these Excel formulas:

BROKERAGE. DOWNLOADED DESCRIPTION CALCULATED FORMULA USED

SCHWAB US TREASU NT 4.125%10/29UST NOTE DUE 10/31/29 10/31/29=RIGHT(B1,8)

VANGUARDU S TREASURY NOTE 4.375 08/31/31 08/31/26 08/31/31=LEFT(RIGHT(B2,17),8)

Anyone have a better method? Thanks.

Statistics: Posted by Luckyoldguy — Thu Sep 17, 2026 6:23 pm