| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Completed Months between Dates
Hi - I'm after a formula to find the number of completed months between
2 dates. This may at times go through to the next year - for example: Cell A1 I have "11:00AM 15/06/09" Cell A2 I have " 3:00PM 25/02/10" Cell B3 I want " 7 " to be returned. Cells A1 and A2 are formatted as hh:hh AM/PM dd/mm/yy Can anyone suggest a formula I can place in cell B3 to return the number of completed months? Tks, Ricky |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of Completed Months | Excel Discussion (Misc queries) | |||
| how do I sort dates by months? | Excel Discussion (Misc queries) | |||
| Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
| months between 2 dates!!! | Excel Discussion (Misc queries) | |||
| Need More Help on Dates to Months | Excel Worksheet Functions | |||
Threaded Mode
