For your assistance please. I am trying to aggregate specific invoices and tried using the movingsum but on the last invoice cut off 4 which the number of days are variable. How can I count and use the movingsum? or is there another formula I can use?
Example : August 2021
Invoice cut off 1 - starting 1st of the month until 7th of the month (fixed 7 days) Invoice cut off 2 - starting 8th of the month until 15th of the month (fixed 8 days) Invoice cut off 3 - starting 16th of the month until 22nd of the month (fixed 7 days) Invoice cut off 4 - starting 23rd of the month until the end of the month (variable)