I have columns which contain formulas for dollar amounts predicted weekly on the basis of incomings and outgoings.
and the rows are the weeks.
The spreadsheet covers the whole year. So the formulas are producing results right into the future and I don’t want to see them right now, especially for printouts.
Am I explaining well enough? Like if I had receipts per week minus expenses per week and a balance per week.
52 rows for 52 weeks.
Works lovely. I can see where we are at today and where we have been for every preceding week since I started this.
But I also see predicted results for the rest of the year which all go into red minus quantities because incomes are predicted - are already coded in but outgoing are not.
Even if they weren’t the thing would still be displaying something, I guess, for the future an that’s what we don’t need to see.
How can I stop it displaying those quantities until we reach that date or perhaps up to I time I specify or perhaps only for the sake of printouts would do?