I am creating a reporting tool which aggregates late dates and displays under which group the data is.
To explain, I have a list of items with dates and delays. I want to create a formula in VBA or SQL to update fields when the date is or "deadline + 5" or "deadline + 10" and so...
In that case, the propreties of the item are: Item Ref (text), Date Received (Date), Deadline + 5 (Yes/No), Deadline + 10 (Yes/No).
I am stuck to add criteria to my formula.
Thank you in advance.