Thread: Subtract a future month from the current month to get remaining m.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fletch Fletch is offline
external usenet poster
  
Posts: 6
Default Subtract a future month from the current month to get remaining m.
I am trying to set up a formula that will give me the remaining periods in a
lease. So if the end of the lease is Jan-2009, then i want to subtract the
current month from Jan-2009 to get a whole integer. ie. (17) months if Jan-09
is included.
With this number i can multiply my payments for each lease to determine my
remaining liability.
Any thoughts?
Reply With QuoteReply With Quote