Thread: Calculate the amount of months between two dates and the days in percentage
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David C[_4_] David C[_4_] is offline
external usenet poster
  
Posts: 1
Default 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
Reply With QuoteReply With Quote