If Between Certain Date Range, Enter Value in "X" Cell

Question

I need some assistance with an excel formula.  I have two columns with date ranges (pay period beginning and end dates), and then a third column with a number in the cell that is associated with the specific date range in that row.  I am trying to create a formula in yet another cell that says "if the date range falls between 'these dates' then enter the number in 'this cell.' 

I'm not sure if it's possible because there are 24 date ranges.

Answer 1

Hi BRIT109

Please, try  in cell F2=IF(AND(E2>=B2,E2<=C2),D2,"")

Hope this is somehow close to your scenario and give you the answer to your problem.

Regards

Answer 2

Hi 

I wonder if this is close to what you looking for.

If not please provide more and clearer details of your scenario.

So we could help you.

Thanks

=IF(B2-A2<C2,"OK","Outstanding")

Regards

Jeovany

Answer 3

I appreciate the help.  I'll try to explain a little more clearly.  Per the example below, I am needing to enter the formula in the cells in column F.  The formula needs to reflect the number in column C that corresponds to the pay period that the date in column E falls under. 

For example, with a date of 1/2/2020 in cell E2, the number that needs to appear in cell F2 is 2.33 (since 1/2/2020 falls within the date range of 12/24/2019 - 1/8/2020).

Second example, with a date of 2/9/2020 in cell E3, the number that needs to appear in cell F3 is 9.33, since the date falls within the date range of 2/8/2020-2/21/2020.

Answer 4

It looks like the screen shot didn't show in my last reply post. Trying it again:

Answer 5

One more time: