If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help Calculating Partial Months between 2 dates.
Hi there. I am trying to obtain the number of months (to 2 decimal
places) between two dates: w4 is 4/4/09 x4 is 6/30/09 Any ideas? Searched extensively but have not come up with a solution. Client needs to show exact number of months to 2 decimal places... Thanks!! |
#2
|
|||
|
|||
Help Calculating Partial Months between 2 dates.
show exact number of months to 2 decimal places...
w4 is 4/4/09 x4 is 6/30/09 What result do you expect based on your sample? The problem with this is that a month is not a standard unit of measure. A month can have 28,29,30 or 31 days. -- Biff Microsoft Excel MVP "sirscottyog" wrote in message ... Hi there. I am trying to obtain the number of months (to 2 decimal places) between two dates: w4 is 4/4/09 x4 is 6/30/09 Any ideas? Searched extensively but have not come up with a solution. Client needs to show exact number of months to 2 decimal places... Thanks!! |
#3
|
|||
|
|||
Help Calculating Partial Months between 2 dates.
Hi,
To get the completed months, use =DATEDIF(C4,C5,"m") where C4 is the beginning date and C5 is the ending date. To get the balance months, use =DATEDIF(C4,C5,"md") Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "sirscottyog" wrote in message ... Hi there. I am trying to obtain the number of months (to 2 decimal places) between two dates: w4 is 4/4/09 x4 is 6/30/09 Any ideas? Searched extensively but have not come up with a solution. Client needs to show exact number of months to 2 decimal places... Thanks!! |
Thread Tools | |
Display Modes | |
|
|