Can anyone be able to simplify this excel formula, do note its working doing exactly what it is intended to do.
=IF(D2>=DATEVALUE("1/7/2024"), IF(D2<=DATEVALUE("6/7/2024"),VLOOKUP(C2,Calendar!$A$13:$E$20,5,FALSE), IF(D2>=DATEVALUE("7/7/2024"), IF(D2<=DATEVALUE("14/7/2024"),VLOOKUP(C2,Calendar!$A$13:$E$20,5,FALSE)*0.75,IF(D2>=DATEVALUE("15/07/2024"), IF(D2<=DATEVALUE("21/07/2024"),VLOOKUP(C2,Calendar!$A$13:$E$20,5,FALSE)*0.5,IF(D2>=DATEVALUE("22/7/2024"), IF(D2<=DATEVALUE("31/7/2024"),VLOOKUP(C2,Calendar!$A$13:$E$20,5,FALSE)*0.25,"f"),"F")),"F")),"F")),VLOOKUP(C2,Calendar!$A$13:$E$20,5,FALSE))
But now I have issue of explaining this to someone who is new to process. So was trying to make is simple by adding function date between which failed also its not inbuilt for me.
1