Hi,
Supose F Is Outstanding Balance, B is Inv. Date G Is Due date & G Is Show Overdues Days Or I Is Receive Amt.
The We Will Put That Formula as received amt. enter the cell 'E' when Cell "D" is do not Show the Value of Overdues Days.
They Will Be Update Automatically Using Excel Formula.
Please Slove the My Qury
Thanks
Vijay Bari.