Forum Discussion
Profit/Loss per Day Calendar
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.
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.
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.
- Thanks Hans 🙂
If is add more rows to "Profit Loss" sheet i will have to renter the formula in the calendar every time. Is there a way to automate the process than me typing formula every time?You can replace $64 (which refers to the last data row on the Profit Loss sheet) with $10000 in one go using the Replace dialog (Ctrl+H).
That way you can fill up to 10000 rows with data.
