Using semi-annual compounding, what is the yield to maturity on a 4.65 percent coupon bond with 18 years left to maturity that is offered for sale at...

Using semi-annual compounding, what is the yield to maturity on a 4.65 percent coupon bond with 18 years left to maturity that is offered for sale at $1,025.95? Assume par value is $1000.

Can not figure out excel formula for this question. Thank you