| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate the amount of months between two dates and the days in percentage
I'm need of a formula that calculates the amount of months from two dates. Also need the percentage of days. Example A1=1st Date to A2=2nd Date and A3=Answer
A1 = 01/01/2017 A2 = 02/15/2017 A3 = 1.5 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate EDATE using days not months? | Excel Discussion (Misc queries) | |||
| Formula to calculate exact months and days between two dates | Excel Programming | |||
| Calculate Count of Days & Average WHERE Amount <0 | Excel Worksheet Functions | |||
| Calculate Number of Months Weeks and Days Between Two Dates | Excel Worksheet Functions | |||
| How do I calculate how many days in which months given two dates . | Excel Programming | |||
![David C[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
