200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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.
Something like this?...
=IF(ISBLANK(E7),"",TODAY()-G7)For cell H7.
I'm confused as to what exactly you want.