Hello Naaib,
Thanks for reaching out and sharing your issues with us. By analyzing the attached file, we understand that you need help with a formula to calculate the average SOFR rate between the range of the specified dates. We can solve the issues using the AVERAGEIFS Function.
Here is the Formula:
=AVERAGEIFS(SOFR!N3:N732, SOFR!M3:M732, ">="&B4, SOFR!M3:M732, "<="&B5)
Don't hesitate to contact us if you have any additional questions or problems regarding Excel. We are here to assist you with any Excel-related issues you may experience.