lease showing payments for each year for years/month payment is applicable

[Darlene C]

I am trying to set up a spreadsheet that will calculate payments for each year (depending on the lease start & end date). I was trying to use the IFS formula to calculate if that item is within that lease date time frame.
So for the Titan utility box: IF (E2) 2019 >= (G2)2018 calculate payments for that year. In this case 2018 wouldn't have a payment because the lease starts in 2019. There would be payments in 2019 (but only from September to December), payments in 2020, payments in 2021, payments in 2022, payments in 2023, and payments only until September for 2024.
Then I will total the payments at the bottom of each year to project for future purchases.

 

[jtakw]

Ok, I'll look into it further later tonight or tomorrow, in the mean time, Please enter Real Dates in G1:S1 as I mentioned previously, it'll give you correct results LESS the proration part.