I've $ Savings from an Action between a 2 Dates, how do i calculate the Savings for the Dates of a Specific Month
What formula can be applied
What formula can be applied
Start Date | End Date | Action Period Savings | 30-Apr-20 | 31-May-20 | 30-Jun-20 | AMJ '20 | 31-Jul-20 | 31-Aug-20 | 30-Sep-20 | JAS '20 | 31-Oct-20 | 30-Nov-20 | 31-Dec-20 | OND '20 | 31-Jan-21 | 28-Feb-21 | 31-Mar-21 | JFM '21 | FY '21 |
27-Apr-20 | 4-Jul-20 | 1000 | |||||||||||||||||
1-May-20 | 30-Jun-20 | 3000 | |||||||||||||||||
15-Jul-20 | 10-Oct-20 | 7400 |