Profit/Loss per Day Calendar

Question

Hi All,&nbsp;I am looking for formula for these 2 items.&nbsp;1. Want total Profit/Loss per date in Calendar (E.g. Total Profit on 02 Feb 2022 was -90.65).&nbsp;2. If Profit Cell to be Green, If Loss cell to be Red&nbsp;&nbsp;Link to Excel Sheet.&nbsp;https://1drv.ms/x/s!AlvQCyQGg78NgkNEsm2PYzAfJIEo?e=bF7ctc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

hansvogelaar · Answer

snipper
In the attached version, I have created the formulas and conditional formatting for February.

hansvogelaar · Answer

Simply enter the year in B1 and select the month from the drop-down in C1.
In the attached version, I have updated the dates from 2022 to 2025.

hansvogelaar · Answer

snipper&nbsp;
Could you attach a sample workbook with some dummy data and a calendar, or make it available through OneDrive/Google Drive/Dropbox/...?

nikolinode · Answer

snipper&nbsp;for colour use..Use a formula to apply conditional formatting in Excel for Mac&nbsp;to show the amount use the formula(set in each cell/calendar day) =IF(A1="",""),A1&nbsp;&nbsp;

snipper · Answer

HansVogelaar&nbsp;&nbsp;https://1drv.ms/x/s!AlvQCyQGg78NgkNEsm2PYzAfJIEo?e=bF7ctc&nbsp;

Forum Discussion

Profit/Loss per Day Calendar

Share

Resources