This might be a stupid question but I'm not an expert (yet) in Excel formulas.
I have used the following formula:
In my column A, I have only dates and in my column B numbers.
I tried a simple IF to compare A with TODAY() and this works perfectly. I have also...