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

Sorry, I guess I can't copy and paste an example.

Answer 3

Dear BRIT109,

Thanks for your updates and effort.

The screenshots you uploaded aren’t uploaded successfully. I’d like you to upload it again here for our clarification.

You can upload the screenshot via clicking on Reply>Insert image.

Please also make sure that the information in the screenshot can be shared here directly and add your confirmation.

Best Regards,

Cliff

Answer 4

Dear BRIT109,

Welcome to share any updates when you have time if you need further help on this issue.

Best Regards,

Cliff

Answer 5

I have the answer I need now, thank you so much!!