Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
number of months in a period
I am trying to determine the number of months that are spanned in a
given period. For example, the number of months spanned in the period 16 Jun 06 to 17 Jul 06 is 2. All the functions in Excel that I have found give the result as 31 days or 1 month. I am trying to avoid creating a lookup table that lists each month of each year as the periods I need to look at will go up to and beyond 2018 (without me knowing) so ideally, the process needs to automated so there are no tables to maintain. I'd be grateful if anyone could advise how I can go about this. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Months within a specific period | Excel Discussion (Misc queries) | |||
Highest 12-Month Period Average Over Range of Months | Excel Worksheet Functions | |||
How do i get rid of the period in a whole number? | New Users to Excel | |||
Loan period in Months | Excel Discussion (Misc queries) | |||
number of mondays in period | Excel Discussion (Misc queries) |