Show how to calculate the bond price at last coupon in excel, NOT finance calculator. I need to know how to get the 973.4 number with a formula in excel.

There is a 4 percent coupon T-note trading in the market today. Its next semi-annual coupon payment is in 53 days. After this coupon payment, the T-note has 9 more semi- annual coupon payments and a final face value payment of $1,000. The quoted asked yield is currently 2.3 percent (compounded semi-annually). The settlement will occur in 2 days. The number of days in the current semi-annual period is 183 days. What is the full (or dirty) price and what is the clean price? Also, what accrued interest do you owe the current owner at settlement? Hint: Calculate the full price first, then the interest, and finally the clean price