ExcelBanter - Calculate the amount of months between two dates and the days in percentage

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Calculate the amount of months between two dates and the days in percentage (https://www.excelbanter.com/excel-worksheet-functions/453916-calculate-amount-months-between-two-dates-days-percentage.html)

David C[_4_]

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

Claus Busch

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

[email protected]

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

All times are GMT +1. The time now is 05:27 PM.