Forum Discussion

snipper's avatar
snipper
Copper Contributor
Mar 14, 2022

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 ...
excel
Excel on Mac
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Sep 24, 2025

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:

  • HotHauling's avatar
    HotHauling
    Copper Contributor
    Apr 27, 2026

    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

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Sep 26, 2025

    I hope the attachment stays this time!

  • lazierflinn's avatar
    lazierflinn
    Copper Contributor
    Sep 25, 2025

    PeterBartholomew1​ I figured it out with the Cnt + H method that Hanz mentioned back in 22, thank you for your response!! 

  • lazierflinn's avatar
    lazierflinn
    Copper Contributor
    Sep 25, 2025

    Hi PeterBartholomew1​ , that makes sense, thank you! Where can I find the workbook with that adjustment?