I want take Pivot table total and divide it by count of days in the month and spread amount across by date. Here is example
# of days count = 10 *** # of days count will change each week so the formula should adjust accordingly
Amount = 5000 **** $50,000/10 should be spread only up to Apr 10 in this example, onward it should zero
Thanks,
Rashid
# of days count = 10 *** # of days count will change each week so the formula should adjust accordingly
Amount = 5000 **** $50,000/10 should be spread only up to Apr 10 in this example, onward it should zero
4/01/18 | 4/02/18 | 4/03/18 | 4/04/18 | 4/05/18 | 4/06/18 | 4/07/18 | 4/08/18 | 4/09/18 | 4/10/18 | 4/11/18 | 4/12/18 | 4/13/18 | 4/14/18 | 4/15/18 |
5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 0 | 0 | 0 | 0 | 0 |
Thanks,
Rashid