| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculate number of months between 2 dates
I have a Start Date and an End Date, need to calculate the number of months in between. Conditions: Start date <=15th includes the month, End date = 15th includes the month. Examples: between 14-04-05 and 15-06-05: 3 months, between 16-04-05 and 13-06-05: 1 month, between 16-02-04 and 03-05-05: 14 months. Thank you. John -- john liem |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Years/Months Between Dates and then Average | Excel Discussion (Misc queries) | |||
| I want to subtract 2 dates and display the result as months | Excel Worksheet Functions | |||
| calculate number of years | New Users to Excel | |||
| Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
| How do I display months and years between two dates | Excel Discussion (Misc queries) | |||
Threaded Mode
