Hello,
My goal is to show the correct total amount per day that will be deposited by extracting the information from contract details.
here is my formula:
My goal is to have a sum of all the cash flows that will be deposited per day.
Column D represents start date
Column H represents first monthly (helps for specific conditions)
Column I represents regular monthly payment
Column J represents the final date
here is an example of two contracts to demonstrate my issue:
Total yearly amount of 36$ that start on 01/01/2019 for 12 months
Total yearly amount of 120$ that start on 01/02/2019 for 12 month
On L3 I typed 01/01/2019 and dragged it until L730 which represents 31/12/2020. typed the formula to M3 and dragged it down.
The result I get is 3$ for 01/01/2019(M3) which is correct but the result i get for 02/01/2019(M4) is still 3$ which is incorrect (supposed to be blank). If I go to 01/02/2019(M35) I do get the correct amount of 13$ (represents 3+10).
Your help is greatly appreciated.
Cross-posting with MrExcel. project due tomorrow, my apologies.
LinkBack URL
About LinkBacks
Register To Reply
Originally Posted by sergiomabres
, On the last reference I had $E$3:$E$10000 instead of $H$3:$H$10000! Your solution works brilliantly.
Bookmarks