A | B | C | |
1 | Sales | Closing Stock | |
2 | 12/Dec | 25 | 75 |
3 | 13/Dec | 30 | 45 |
4 | 14/Dec | 45 | 0 |
5 | 15/Dec | 60 | -160 |
6 | |||
7 | Opening Stock | 100 | |
8 | Runout | ???? | Needs to return 14/Dec |
<tbody>
</tbody>
How do I get cell B8 to return the date 14/Dec as the date stock runs out? I have used IF formula but I am doing something wrong?
Thanks in advance...
Churmie