Hi all,
I have a problem that I can't get the updated overdue date. The thing is when I remove a row from Overdue tab, the Outgoing tab column M should get the overdue days once it is return back shown in Incoming tab.
Not sure how to derive the formula to get my result, will appreciate someone can give me some hint.
In the uploaded link, The WW11 and WW12 will be on different workbook. I place them in single workbook for ease reference and to understand why I need to find M14 cell result at OutgoingWW12 tab
Thank you.
Google drive link : https://drive.google.com/open?id=1nSMseYa0VNPz7hG9aM6Ts0kAdZrK29ix
I have a problem that I can't get the updated overdue date. The thing is when I remove a row from Overdue tab, the Outgoing tab column M should get the overdue days once it is return back shown in Incoming tab.
Not sure how to derive the formula to get my result, will appreciate someone can give me some hint.
In the uploaded link, The WW11 and WW12 will be on different workbook. I place them in single workbook for ease reference and to understand why I need to find M14 cell result at OutgoingWW12 tab
Thank you.
Google drive link : https://drive.google.com/open?id=1nSMseYa0VNPz7hG9aM6Ts0kAdZrK29ix
