Trying to make an interface with a “maximum possible spend” for each project launch day. Projects launch twice a week and run from 2 days to 15 days. I need to find a way to ask the question “Is this project still running next Tuesday” and “is the project still running next Friday”.
Does anyone know where to start? I’ve tried a few things, I’ve tried lots of nested if statements, but I’m truly stumped.
EDIT: A better way of formatting the question is “Will this product still be available for purchase next Tuesday/Friday” as two separate columns with a true/false value.