MicMadness
New Member
- Joined
- Oct 15, 2024
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
- MacOS
Hello,
I am looking to finish a simple sheet. I am looking to calculate interest from certain dates on a specific party, to an ending date. The ending date is where I am struggling having the calculation for interest take place. I have a screenshot of the algorithms being used currently, and everything works great, except getting Party B's interest from the dates in B2 to a specific ending date(one algo will be until 05/18/2023 and the other is until 05/22/2023. All others are through "Today" which is easily implemented already. Essentially, trying not to pay someone for an extra year and 1/2 at the agreed rate.
I am looking to finish a simple sheet. I am looking to calculate interest from certain dates on a specific party, to an ending date. The ending date is where I am struggling having the calculation for interest take place. I have a screenshot of the algorithms being used currently, and everything works great, except getting Party B's interest from the dates in B2 to a specific ending date(one algo will be until 05/18/2023 and the other is until 05/22/2023. All others are through "Today" which is easily implemented already. Essentially, trying not to pay someone for an extra year and 1/2 at the agreed rate.
