SOLVED

Pourcentage Date

Copper Contributor

Hello, i'm trying to do a portfolio project for my company. 

In one of the colonn, i tried to do the pourcentage the date yith a DATEDIF formula. But i don't understand the formula isn't correct. 

Formula : =(DATEDIF(A5,AUJOURDHUI(),"d")+1)/(DATEDIF(A5,B5,"d")+1)

Thank you for your help.

Sincerly,

 

3 Replies
best response confirmed by RSEdevelpper (Copper Contributor)
Solution

@RSEdevelpper Why use DATEDIF in the first place?

 

Try this:

=(AUJOURDHUI()+1-A5)/(B5-A5+1)

 

and format the end result as a percentage.

Thank you for the answer, i first used this website : https://fr.extendoffice.com/documents/excel/5901-excel-calculate-percentage-between-two-dates.html
For the first formula.

@RSEdevelpper That may well be, but DATEDIF isn't an official Excel function. This is what the MS support pages write about it:

 

Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function may calculate incorrect results under certain scenarios. Please see the known issues section of this article for further details.

1 best response

Accepted Solutions
best response confirmed by RSEdevelpper (Copper Contributor)
Solution

@RSEdevelpper Why use DATEDIF in the first place?

 

Try this:

=(AUJOURDHUI()+1-A5)/(B5-A5+1)

 

and format the end result as a percentage.

View solution in original post