Hello!
I wrote this function but it does not work:
=IF($I$28<=D17<($I$28+7),G28,C18-$C$28*0.2)
I want the IF function to check the date at D17 to be between the date $I$28 and $I$28 + 1 week. How do I do that?
Secondly, I want to calculate the mathematical function C18-$C$28*0.2 but I want...