Hey guys,
Am trying to work out an automatic cash flow based on invoice date and payment terms.
I've attached an example with the desired formula result in cells C2:I2.
Can anyone shed some light on this?
Hey guys,
Am trying to work out an automatic cash flow based on invoice date and payment terms.
I've attached an example with the desired formula result in cells C2:I2.
Can anyone shed some light on this?
Last edited by Sthomson1984; 05-18-2017 at 01:00 AM.
c2=SUMPRODUCT((COLUMN(C$2)-COLUMN($C$6:C$10)=CEILING($B$6:$B$10/30,1))*($C$6:C$10))
Try this and copy towards rightPlease Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Awesome, thanks heaps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks