IF stament wih date ranges and between

[guaya81]

Hello

anybody can help me solve a formula to check if the inv date fall between a promo allowance and if so get that promo allowance % and multiply by case, below is the data incentive table that im referring, I will like to bring the percentage

Family Product	15% rebate	Cat Incentive	beginnig date	end date
Oral Care	15%	3.0%	4/1/2018	4/30/2018
Hair Care	15%	0.0%	4/1/2018	4/30/2018
Fem Care	15%	3.0%	4/1/2018	4/30/2018
Shave Care	15%	15.0%	4/1/2018	4/30/2018
Fabric Care	15%	0.0%	4/1/2018	4/30/2018
Family Care	15%	0.0%	4/1/2018	4/30/2018
Home Care	15%	2.5%	4/1/2018	4/30/2018
Baby Care	15%	0.0%	4/1/2018	4/30/2018
PCC	15%	0.0%	4/1/2018	4/30/2018
Deodorants	15%	0.0%	4/1/2018	4/30/2018
Oral Care	15%	3.0%	1/1/2018	1/31/2018
Hair Care	15%	0.0%	1/1/2018	1/31/2018
Fem Care	15%	3.0%	1/1/2018	1/31/2018
Shave Care	15%	10.0%	1/1/2018	1/31/2018
Fabric Care	15%	0.0%	1/1/2018	1/31/2018
Family Care	15%	0.0%	1/1/2018	1/31/2018
Home Care	15%	3.0%	1/1/2018	1/31/2018
Baby Care	15%	3.0%	1/1/2018	1/31/2018
PCC	15%	0.0%	1/1/2018	1/31/2018
Deodorants	15%	0.0%	1/1/2018	1/31/2018
Skin Care	15%	0.0%	1/1/2018	1/31/2018
Oral Care	15%	3.0%	2/1/2018	2/28/2018
Hair Care	15%	0.0%	2/1/2018	2/28/2018
Fem Care	15%	3.0%	2/1/2018	2/28/2018
Shave Care	15%	10.0%	2/1/2018	2/28/2018
Fabric Care	15%	0.0%	2/1/2018	2/28/2018
Family Care	15%	0.0%	2/1/2018	2/28/2018
Home Care	15%	2.5%	2/1/2018	2/28/2018
Baby Care	15%	2.5%	2/1/2018	2/28/2018
PCC	15%	0.0%	2/1/2018	2/28/2018
Deodorants	15%	0.0%	2/1/2018	2/28/2018
Skin Care	15%	0.0%	2/1/2018	2/28/2018

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

thanks

 

[Peter_SSs]

What about you now give us an example or two of what you are trying to look up in that data and what the results are and how they would be presented?