| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count months between years
Hi -I need to calculate the months between years.
Eg. Start month Sept 08, end month April 2015. Thanks in anticipation. Naeem |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count months between years
Use the DATEDIF function.
It doesn't have a helpfile in excel, but a good page for it he http://www.cpearson.com/excel/datedif.htm -- Location: Sydney Occupation: Actuarial Consultant (Project Finance/Financial Modeling) "dqm" wrote: Hi -I need to calculate the months between years. Eg. Start month Sept 08, end month April 2015. Thanks in anticipation. Naeem |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count months between years
Try this with the earlier date in a1
=DATEDIF(A1,A2,"m") Mike "dqm" wrote: Hi -I need to calculate the months between years. Eg. Start month Sept 08, end month April 2015. Thanks in anticipation. Naeem |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count months between years
http://www.cpearson.com/excel/datedif.aspx
-- David Biddulph "dqm" wrote in message ... Hi -I need to calculate the months between years. Eg. Start month Sept 08, end month April 2015. Thanks in anticipation. Naeem |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting months between two years | Excel Discussion (Misc queries) | |||
| Dates - Months & Years | Excel Worksheet Functions | |||
| converting months to years and months??? | Excel Discussion (Misc queries) | |||
| Converting months to years | Excel Worksheet Functions | |||
| years and months | Excel Worksheet Functions | |||
Linear Mode
