I have a sheet which is used to record food menu items.
Col A contains the date and B the item.
On the RHS side of the sheet I have a list of items used and a column which totals the time they have been used since day 1.
I now want to add a column to show me the last date used of that item.
At the moment I do this by adding the date when I put the entry in col A.
Is there a way to do this automatically?
example
| date | menu item | menu item | times used | date last used |
|---|---|---|---|---|
| Sat 9 Jul 22 | Slow-cooked chicken | Slow-cooked chicken | 7 | Sat 9 Jul 22 |