MR_EXCEL_16
New Member
- Joined
- Jul 9, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello Friends! I am new to excel, need your help. Here is the situation...
Total Savings: E.g. 1 ... $2898 needs to equally spread between May'20 till Jun'20. Months prior and after Start & End Date needs to reflect 0.
Thank you in advance.
Total Savings: E.g. 1 ... $2898 needs to equally spread between May'20 till Jun'20. Months prior and after Start & End Date needs to reflect 0.
S. No. | Total Savings | Start Date | End Date | Total Weeks | Apr'20 | May'20 | Jun'20 | Jul'20 | Aug'20 | Sep'20 | Oct'20 | Nov'20 | Dec'20 |
1 | $2,898 | 5/15/2020 | 7/20/2020 | 7 | |||||||||
2 | $3,577 | 6/12/2020 | 6/28/2020 | 1 |
Thank you in advance.