Find a value based on dates

[laxmaster3000]

Hi Everyone,

I'm trying to find a way to pull data values from one sheet and enter them into a table on another sheet.

For example, on May 1st 2018 100% of a job is completed:

01-May-18	100%
27-Apr-18	98.75%
26-Apr-18	93%
10-Apr-18	83%
01-Apr-18	75%
15-Mar-18	50%
01-Mar-18	20%
01-Feb-18	5%

<colgroup><col><col></colgroup><tbody>
</tbody>

I want to set up another table that shows month to month progress for various projects:

Start	90 Days	60 Days	30 Days	Finish
0%	5%	20%	75%	100%

<colgroup><col width="72" span="5" style="width:54pt"> </colgroup><tbody>
</tbody>

How can I get these numbers using a formula?

Thanks for the help!

 

[Special-K99]

If you want month to month progress you should stick with the month dates (01-Feb-18, 01-Mar-18, 01-Apr-18, etc) and not have 30 60 90 days.
That way you can just use a simple VLOOKUP to return the percentage if there is always an entry for the 1st of the month.

Let's do it your way: 01-May-18 minus 90 days is NOT 01-Feb-18, it's 31-Jan-18.
You have no percentage for 31-Jan-18 in your table.

 

[laxmaster3000]

Yes that's what I ended up doing, I standardized the dates reporting progress and used vlookup

Thanks!