I am currently building an Excel worksheet for managing inventory in a large kitchen and I would like to find the value of the inventory for the most recent day.
Inventory is taken four days a week and each row in the table has a price value. What I am trying to do is multiply the inventory for the most recent day in the row.
So if I put in
MON then the value would update to
If I add
TUE then the value would change to
The way I have it set now, it just adds up all the values MON through THU and doesn't give me a daily calculation.