Forum Discussion
Profit/Loss per Day Calendar
Hi All, I am looking for formula for these 2 items. 1. Want total Profit/Loss per date in Calendar (E.g. Total Profit on 02 Feb 2022 was -90.65). 2. If Profit Cell to be Green, If Loss cell to ...
That is because the formula specified a specific range that matches the data.
I have modified HansVogelaar's workbook to use a table for the profit/loss data that should resize as data is appended. The names are defined in terms of table structured references.
The missing attachment:
On all of these calendar attachments I have noticed the following months do not appear from the profit/loss sheet to the calendar sheet. I have been trying to find the formula to use and how to do it but im failing. can you please explain