Forum Discussion
snipper
Mar 14, 2022Copper Contributor
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 ...
HansVogelaar
Mar 14, 2022MVP
Could you attach a sample workbook with some dummy data and a calendar, or make it available through OneDrive/Google Drive/Dropbox/...?
- snipperMar 14, 2022Copper Contributor
- HansVogelaarMar 14, 2022MVP
In the attached version, I have created the formulas and conditional formatting for February.
- FlinnLazierFeb 28, 2025Copper Contributor
HansVogelaarFirst off I want to thank you for the calendar as it has been perfect for journalling. I wanted to ask how I can format March and the coming months? I attempted to replicate the formula from February to March by changing values such as going from Calendarmonth1 to Calendarmonth2 and populating the cells for the March month, but I don't get any values. Would appreciate any help available as I really enjoy this sheet.