| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate the amount of months between two dates and the days in percentage
Hi,
Am Sat, 18 Nov 2017 10:39:20 -0800 (PST) schrieb David C: 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 try: =ROUND((A2-A1)/30.436875,2) Regards Claus B. -- Windows10 Office 2016 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate the amount of months between two dates and the days in percentage
On Saturday, November 18, 2017 at 2:32:44 PM UTC-6, Claus Busch wrote:
Hi, Am Sat, 18 Nov 2017 10:39:20 -0800 (PST) schrieb David C: 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 try: =ROUND((A2-A1)/30.436875,2) Regards Claus B. -- Windows10 Office 2016 Wow...Thank you Sir! You're awesome |
| Reply |
| 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)
Linear Mode
