Hudson
12-06-2016, 01:46 PM
Hi all,
Wondering if there is a way to identify the day and its corresponding week in the month and dollar needs to summed in another sheet.
For example.
I have file with two tabs in it (Cash Receipt) and (Forecast) in cash report I update a daily dollar’s value and in forecast its is a consolidated sheet that has everything in the month . now when cash come for example from account number (40000035 ) on 12/01/2016 it is first week of the month and the same customer paid on 12/10/2016 that should reflect on week 2 column and so on . he may pay 5 times in five weeks time in a month . I want to capture that in forecast report .
Attached is the file for your reference.
Wondering if there is a way to identify the day and its corresponding week in the month and dollar needs to summed in another sheet.
For example.
I have file with two tabs in it (Cash Receipt) and (Forecast) in cash report I update a daily dollar’s value and in forecast its is a consolidated sheet that has everything in the month . now when cash come for example from account number (40000035 ) on 12/01/2016 it is first week of the month and the same customer paid on 12/10/2016 that should reflect on week 2 column and so on . he may pay 5 times in five weeks time in a month . I want to capture that in forecast report .
Attached is the file for your reference.