| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of Completed Months
Hi,
How can I get the number of COMPLETED months returned between 2 dates? At times it may be grater than 12 months - but never greater than 24 months. I've been fiddling with =Floor and =Ceiling but when the dates are in a different year it has me stumped. For example ... A1 = 15-Jun-07 A2 = 23-Oct-08 Need a formula to return "15" months Tks, Kaye |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Month name to number of months YTD | Excel Worksheet Functions | |||
| Number of tasks completed in a specific time frame | Excel Discussion (Misc queries) | |||
| how do I convert a number to number of years, months and days | Excel Worksheet Functions | |||
| Number of months between 2 dates | New Users to Excel | |||
| Want a number of cells to be auto completed based on entry in one. | Excel Worksheet Functions | |||
![Rick[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
