Calculate Percentiles

I have a stream of data that is active and i need to calculate where a number is relative to the percentile range. I have a static 25th,50th,65th, 75th,90th range. When I enter a number I want a calculation to tell me what percentile it is between that range.

Below is my static percentile range. I would like to calculate where what percentile is 5,312 based off of this range. I know about the percentile function but with that one you seem to have to tell it the percentile, I want a calculation that would tell me what the percentile is based off a percentile range 25th to 90th and where it is between those values or sometimes outside of those values.

25th 50th 65th 75th 90th
3,991.71 4933.69 5,472.96 5,896.16 7,066.05

Maybe someone already encountered this issue.

Thanks.

57.1 Percentile is what I calculate.

This data that I have attached with calculations came from a consulting company. It is not something I developed personally as I do not have a good statistical background for this. Just to give you a background, this data is used to calculate a monthly productivity percentile based off of a numeric input. I have over 200 dashboards in excel which I send out each month through a PDF and email process. At the bottom of these dashboards contains this data which I have attached above. So for each month I report the monthly productivity number, then I annualize it (because these 25th, 50th 65th, 75th, and 90th) percentile spreads are annual totals and measure the input against these spreads. Because I have to repeat this each month I have a bit of a mess below each of these dashboards. So when February happens, I add January and February together, then annualize and measure the percentile. When March passes, I add Jan, Feb, March then annualize and measure against spread. So I have sections for each month in order to accomplish me calculation the percentile and inputting it into the dashboard. Where I was going with this, I was hoping to eliminate some of these calculations that I have attached above with some kind of an easy formula. So I was thinking have a formula where I can annualzie and measure against a table of these percentile spreads and input in the corresponding month.
Yes and I think you are correct they are assuming this is a normally distributed data which is probably false but a simple way of doing things mechanically. These percentiles come from national surveys and the surveys do not share the complete spread of percentiles so we have to guess based off a normal distribution.

I will take a look at your post you referenced below point 3) to see if it is helpful.

but thank you for taking the time to dissect my problem and responding.