| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of Months Counts
Would like to know the function that returns the number of months, for
example to return 20 for the months from Feb-2008 to Sep-2009. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of Months Counts
Have a look at DATEDIF. This is undocumented but Chip tells all at
www.cpearson.com best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Jalal" wrote in message ... Would like to know the function that returns the number of months, for example to return 20 for the months from Feb-2008 to Sep-2009. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of Months Counts
And if you weren't aware of the DATEDIF function that Bernard referred you
to, you could always do it the long way... =12*(YEAR(B10)-YEAR(A10))+MONTH(B10)-MONTH(A10)+1 where it is assumed your begin date is in A1 and your end date is in B1. Rick "Jalal" wrote in message ... Would like to know the function that returns the number of months, for example to return 20 for the months from Feb-2008 to Sep-2009. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of Months Counts
Thanks guys.
"Rick Rothstein (MVP - VB)" wrote: And if you weren't aware of the DATEDIF function that Bernard referred you to, you could always do it the long way... =12*(YEAR(B10)-YEAR(A10))+MONTH(B10)-MONTH(A10)+1 where it is assumed your begin date is in A1 and your end date is in B1. Rick "Jalal" wrote in message ... Would like to know the function that returns the number of months, for example to return 20 for the months from Feb-2008 to Sep-2009. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number counts within Date Range | Excel Worksheet Functions | |||
| Month name to number of months YTD | Excel Worksheet Functions | |||
| A macro that counts the number of times a file is opened | Excel Discussion (Misc queries) | |||
| a function that counts the number of cells with information | Excel Worksheet Functions | |||
| how do I convert a number to number of years, months and days | Excel Worksheet Functions | |||
Linear Mode
