Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a worksheet with a beginning and ending date range. I need the number
of months for the range but also need them rounded up to the next month. For example: 13-Jul-11 to 31-Jul-12 should calculate as 13 months and not the 12 provided by the DATEDIF function. In short, I need to round up to the next month for my calculations. 05-Mar-11 to 31-Dec-11 should return 10 full months and not 9. Is there an easy way to do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date calculations | Excel Discussion (Misc queries) | |||
More date calculations | Excel Worksheet Functions | |||
Date Calculations before date entered | Excel Discussion (Misc queries) | |||
Date calculations | Excel Discussion (Misc queries) | |||
Date Calculations | Excel Worksheet Functions |