Forum Discussion
Setting recurrent dates in a cell
Hi, I hope someone can help me. I have a cell with a date in it based on a formula, Cell C = A1+B1 A B C Last Order Date Order Cycle (days) Next ...
Of course, so much depends on what this is being used for. I'm reading it as a situation where you need to remind yourself to make an order (say for some kind of essential supply, either for home or for work) and need to highlight the situation on a dashboard of some kind when that re-order hasn't happened.
When it has, you change the date in cell A and the urgent reminder is turned off. You give yourself a 7 day period of grace.
If the situation is something more mechanical, by all means, describe it.