I have the following formula:
It checks if the cell in C9 is blank (which it is not, the text is just hidden) and then returns the current date of today.
However, I am also referring to cell C7 in another cell, specifically like this:
My issue is, obviously, that the cell...
So I have a workbook with two sheets
Sheet 1 (Demand)
Has a table of all of the items on the sales for a specific date and the quantities.
Column A= Item #
Column B=Sales order #
Column C=Date of sales order
Column D=Qty of Item on order