[Solved] Average on dates

[Naaib]

Hi

I am facing some difficulty to get the values needed for the average if formula.

Need some help on this. i have annex the template.

 

[Lutfor Rahman Shimanto]

Hi

I am facing some difficulty to get the values needed for the average if formula.

Need some help on this. i have annex the template.

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.

Regards
Lutfor Rahman Shimanto (ExcelDemy Team)