Hello Excel Experts,
I would like to know if there is a way i can automate my P&L savings (Profit and Loss) in excel since currently i am doing it manually.
Our P&L date savings calculation is not from Jan to Dec but from Nov 01, 2013 to Oct 31, 2014 for YR 2014 and from Nov 01, 2014 to Oct 31, 2015 for YR 2015.
Here's the scenario:
1) In column A, i have my annual savings of US$ 120,000. My column B is P&L Date. If i entered any date from Nov 01 to Nov 30, the calculated P&L Savigns in column "C" should be US$ 120,000 (12 months from Nov to Oct).
2) In reference to the above, if i have entered any date in column B from Dec 01 to Dec 31, the computed P&L savings in C should be US$ 110,000 (only 11 months from Dec to Oct)
Appreciate your help if this is possible without macros.
Thanks.
I would like to know if there is a way i can automate my P&L savings (Profit and Loss) in excel since currently i am doing it manually.
Our P&L date savings calculation is not from Jan to Dec but from Nov 01, 2013 to Oct 31, 2014 for YR 2014 and from Nov 01, 2014 to Oct 31, 2015 for YR 2015.
Here's the scenario:
1) In column A, i have my annual savings of US$ 120,000. My column B is P&L Date. If i entered any date from Nov 01 to Nov 30, the calculated P&L Savigns in column "C" should be US$ 120,000 (12 months from Nov to Oct).
2) In reference to the above, if i have entered any date in column B from Dec 01 to Dec 31, the computed P&L savings in C should be US$ 110,000 (only 11 months from Dec to Oct)
Appreciate your help if this is possible without macros.
Thanks.