Forum Discussion
Profit/Loss per Day Calendar
Hi All,
I am looking for formula for these 2 items.
11 Replies
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.
Hey guys, sorry to keep bothering. I did have a quick question. It seems that the work book doesn't work past 64 entries in the journal, does anyone know why that is and if there is a fix?
for colour use..
Use a formula to apply conditional formatting in Excel for Mac
to show the amount use the formula
(set in each cell/calendar day)
=IF(A1="",""),A1
Could you attach a sample workbook with some dummy data and a calendar, or make it available through OneDrive/Google Drive/Dropbox/...?
In the attached version, I have created the formulas and conditional formatting for February.
