Hello
so I have the invoice with it's data available in each row
so I wanna the value in Grand total column to move in automatic way to it's place according to the number of days to the due date
so the Vendor DS has due date on 27-November-2020 so I want an equation to make a copy of the 7500 to column H
so today is 17-November-2020 and it has 10 days to 27-November-2020 so the equation will list the number on that column 0-30 days.
is there a way to do this?
the file attached as a sample
so I have the invoice with it's data available in each row
so I wanna the value in Grand total column to move in automatic way to it's place according to the number of days to the due date
so the Vendor DS has due date on 27-November-2020 so I want an equation to make a copy of the 7500 to column H
so today is 17-November-2020 and it has 10 days to 27-November-2020 so the equation will list the number on that column 0-30 days.
is there a way to do this?
the file attached as a sample