I have a lease that runs until the end of June 2015 and I'm trying to figure out the amount of the remaining payments, so need to figure out the time remaining as far as how many full months as well as % share left for any partial months.
For example, today is 8/29/13 and there are 31 days in the month. If the lease payment was $100/month they would owe (3/31)*100 or $9.68 for this month. Next month is September, which has 30 days, so if I were looking at it next month I'd have to figure out the remaining days / 30 to figure out the payment.
I know I can used the "datedif()" function to figure out the whole months remaining, but how can I determine the remaining days for the current month and divide that by the number of days in the month?
Bookmarks