The upload file number is 834788
Hopefully this will get to you. This morning each time I hit reply I got a message that I did not have access to the server. Cell B10 will be manually changed, for example from 21 to 19 or perhaps 15, etc. The formula for each day for collections should take into account the number of days in B10 and pick the correct days sales to become collections. For example, if B10 contains 21, Jan. 22 collections (W6)should show the contents of Jan. 1 sales (B5). If B10 contains 19, Jan. 22 collections (W6) should show the contents of Jan. 3 sales (D5). The collections formula needs to handle any number of days entered in B10 and CHOOSE the sales from the correct day to show as collections for that day.