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?
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.
