ExcelNewbie2020
Active Member
- Joined
- Dec 3, 2020
- Messages
- 293
- Office Version
- 365
- Platform
- Windows
how to allocate the amount from the number of days in a month from start to end.
below table shows an amount of 30000 to be proportionally allocated per month based on the number of days in each month starting from 13/01/2023 to 30/04/2023? thank you
below table shows an amount of 30000 to be proportionally allocated per month based on the number of days in each month starting from 13/01/2023 to 30/04/2023? thank you
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | start | end | amount | expected result | ||||||
2 | 13-01-23 | 30-04-23 | 30000 | jan | feb | mar | apr | |||
3 | 5,046.73 | 7,850.47 | 8,691.59 | 8,411.21 | ||||||
4 | ||||||||||
5 | ||||||||||
6 | ||||||||||
Sheet3 |