| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to calculate exact months and days between two dates
In cell A1 and B1 I have dates (see below)
30/05/2006 12/08/2009 In cell A2 I have formula (see below) which produce the result 39 months (YEAR(B1)-YEAR(A1))*12+MONTH(B1)-MONTH(A1) I am looking for formula which should tell me exact months and days between two dates as difference in above dates are 38 months and 12 days but I don’t know how to achive this by formula. Please can any friend can help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How calculate exact # of months between two dates? | Excel Worksheet Functions | |||
| Calculate Number of Months Weeks and Days Between Two Dates | Excel Worksheet Functions | |||
| Formula to calculate number of days between Dates | Excel Worksheet Functions | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| How do I calculate how many days in which months given two dates . | Excel Programming | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
