Dustychickpea
New Member
- Joined
- May 5, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi All,
I have been racking my brains to come up with a suitable formula for quite a specific scenario.
In row 22 (highlighted) I need values pulled through calculating what is marked under columns week 1-4 (E10: H16) factoring in payment terms (column D) in days. the theory is that depending on the terms of payment, "cash received" in row 22 would calculate which week it would arrive. Any idea if this is possible? I know that this can be achieved by column representing 1 day only, but that would not work for this specific workbook.
Any help would be greatly appreciated.
I have been racking my brains to come up with a suitable formula for quite a specific scenario.
In row 22 (highlighted) I need values pulled through calculating what is marked under columns week 1-4 (E10: H16) factoring in payment terms (column D) in days. the theory is that depending on the terms of payment, "cash received" in row 22 would calculate which week it would arrive. Any idea if this is possible? I know that this can be achieved by column representing 1 day only, but that would not work for this specific workbook.
Any help would be greatly appreciated.