Forum Discussion
Solved
How to perform a formula on a specific date, then stop performing it after that date.
Hi all. New here but in desperate need to know if this is possible. I'm trying to figure out if there's a way to perform a formula only on a specific date, and once the date has passed, it'll kee...
Does the attached workbook give you something to work with?
HansVogelaar It certainly gives me a starting point! thank you. Question though, and forgive me for being such a beginner, but in the formula where it says if b2="", "" what do the "" refer to? what is it saying exactly?
If the Actual sales amount in column B is "" (empty), we don't want to return an Over/Short amount, so the formula returns an empty string "". Otherwise, it calculates the Over/Short amount based on the Actual amounts up to and including that day.