| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract a future month from the current month to get remaining m.
=DATEDIF(TODAY(),End_Date,"m")
-- Regards, Peo Sjoblom "Fletch" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
| Count workdays remaining in a month | Excel Discussion (Misc queries) | |||
| Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
| Calculate the first day of the month for the current month? | Excel Discussion (Misc queries) | |||
| End of month in the future.. | New Users to Excel | |||
Linear Mode
