Hello,
I am trying to calculate what date 2/3 of a lease would be. If start date is 5/8/13 and expiration date is 3/19/12 on a 36 month lease, how do I find out the date 2/3rds into it?
Hello,
I am trying to calculate what date 2/3 of a lease would be. If start date is 5/8/13 and expiration date is 3/19/12 on a 36 month lease, how do I find out the date 2/3rds into it?
I presume your dates are in month-day-year format, though I don't understand how the expiration date can be BEFORE the start date. Doesn't a 36-month lease mean that it will finish 3 years later, and so 2/3 of that is two years later?
Maybe I'm missing something.
Pete
I didn't notice my typo. Start date is 5/8/13 and term date is 3/19/15 on a 36 month lease. So I am trying to find a formula that will tell me when the lease is 2/3 of the way to the term. I do have my start and term date fields set at month-day-year. Not all the terms are the same. We have terms that go from 12 month to 63 months.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks