Forum Discussion
Help with excel formulas
Good evening, I am trying to create a holiday tracker to track my colleagues holiday allowance. So my plan is the following. Cell A1 hours Used Cell B1 hours remaining Cell C1 Annual holiday All...
Subtracting within the same cell is tricky:
- You won't have a history of hour's used, and because of that:
- It's not easy to spot and to correct a mistake, or an alteration.
I'd do it - for example - like this:
The formulas in column B are:
You can fill down the formula from B3 downwards.
Thank you, I had a feeling this would be the case. Thanks the for the advice 🙂