Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Complete Months Between Two Dates
I need to calculate leavers holiday entitlement where only the number of
fully completed months are included. A month where the start date is after the first, or a month where the end date is prior to the last day of the month are not included. Example: Start Date: 15 January End Date: 26 June Full Months: 4 (Feb; Mar; Apr; May) The start and end dates will be entered into cells; Is there a definhed function to calculate this or what formula would I need? Thanks, as always, for any assistance. Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I calculate fractional months between two dates? | Excel Discussion (Misc queries) | |||
Calculate number of months between dates | Excel Worksheet Functions | |||
Calculate number of months between 2 dates | New Users to Excel | |||
Calculate number of months between 2 dates | New Users to Excel | |||
Calculate Years/Months Between Dates and then Average | Excel Discussion (Misc queries) |