Forum Discussion
Profit/Loss per Day Calendar
Hi All,
I am looking for formula for these 2 items.
15 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.
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
I hope the attachment stays this time!
PeterBartholomew1 I figured it out with the Cnt + H method that Hanz mentioned back in 22, thank you for your response!!
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.
