# Data to appear when between 2 dates - Round 2

#### bobgrand

##### Board Regular
OK, Let's try this again.
I hope this makes more sense and look forward to see some responses if this is at all possible. I currently do all of this manually for a project that will be going on over the next 18 months.
On the Due Day in column B, I would like to see the quantities in column A show up on or before the Order Date but not on the date prior to the upcoming Order Date in row 1.
Using the Today's Date formula in A1, lets say today is May 7, I would like to see the quantities in column A show up in cells E7, E8 & E9. Quantities should only show up when the due day is on or before the order date but after the date prior to the current order date. I would enter the order on 05/08/19 and order the quantities that are due by day 9, 11 and 13.
All the quantities in columns F thru J would be blank because those dates have not arrived yet. The ordering cycle is always Wed, Wed, Fri, Wed Wed, Fri, etc.

I really hope I explained this well enough to understand and I hope I have put your excel skills to the challenge.

 A B C D E F G H I J 1 05/13/19 Order date> wed 05/01/19 fri 05/03/19 wed 05/08/19 wed 05/15/19 fri 05/17/19 wed 05/22/19 wed 05/29/19 fri 05/31/19 2 qty Due Day 3 200 1 200 4 50 3 50 5 200 5 200 6 20 7 20 7 10 9 10 8 25 11 25 9 60 13 60 10 50 15 50 11 200 17 200 12 50 19 50 13 200 21 200 14 20 23 20 15 10 25 10 16 25 27 25 17 60 29 60 18 50 31 31

<tbody>
</tbody>

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### etaf

##### Well-known Member
sorry, i dont fully understand
How does excel know the due date ...

A1 = todays date - so that will keep changing

B3 = Due Date - and has a 1 in the cell, which I assume means 1 day after some date - but it cant be today() cell, as every day the spreadsheet date will change in A1 and so those orders will change

A1 = 15th May
C3 has 200 , under 1st may column

OR
is B3 showing the day of the month - so 1 = 1st of month based on the month from A1

so if you open the spreadsheet on 1st June - what happens ??

#### bobgrand

##### Board Regular
sorry, i dont fully understand
How does excel know the due date ... <<< This is where I need help with the formula

A1 = todays date - so that will keep changing
This is correct

B3 = Due Date - and has a 1 in the cell, which I assume means 1 day after some date - but it cant be today() cell, as every day the spreadsheet date will change in A1 and so those orders will change
Column B - DUE DAY = The day of each month. This is where I can't figure out a formula. If the day in the order date is on or before the DUE DAY in column B but greater than the previous Order Date.

A1 = 15th May
C3 has 200 , under 1st may column

If A1 = 1st May populate the value in A3 to C3
If A1 = 7th May than populate the values from Column A, 10, 25, 60 to cells E7, E8, E9
If A1 = 15th May than populate the value from A10 to F10
If A1 = 16th May than populate the values from A11, A12, A13 to cells G11, G12, G13

OR
is B3 showing the day of the month - so 1 = 1st of month based on the month from A1
Correct B3 thru B18 are days of the month. These are manual typed values and not in any way at the moment using A1

so if you open the spreadsheet on 1st June - what happens ??
I have no formulas to make this happen yet as I am having trouble with with using the due day with the order date formula to make this happen.