SOLVED

Pourcentage Date

%3CLINGO-SUB%20id%3D%22lingo-sub-2885098%22%20slang%3D%22fr-FR%22%3EPercentage%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2885098%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%2C%20i'm%20trying%20to%20do%20a%20portfolio%20project%20for%20my%20company.%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20one%20of%20the%20colonn%2C%20i%20tried%20to%20do%20the%20percentage%20the%20date%20yith%20a%20DATEDIF%20formula.%20But%20i%20don't%20understand%20the%20formula%20isn't%20correct.%26nbsp%3B%3C%2FP%3E%3CP%3EFormula%3A%20%3CSTRONG%3E%3CSPAN%20class%3D%22%22%3E%3D(DATEDIF(A5%2CTODAY()%2C%22d%22)%2B1)%2F(DATEDIF(A5%2CB5%2C%22d%22)%2B1)%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help.%3C%2FP%3E%3CP%3ESincerly%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2885098%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2885251%22%20slang%3D%22en-US%22%3ERe%3A%20Pourcentage%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2885251%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1196120%22%20target%3D%22_blank%22%3E%40RSEdevelpper%3C%2FA%3E%26nbsp%3BWhy%20use%20DATEDIF%20in%20the%20first%20place%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%3A%3C%2FP%3E%3CP%3E%3D(%3CSTRONG%3E%3CSPAN%20class%3D%22%22%3EAUJOURDHUI%3C%2FSPAN%3E%3C%2FSTRONG%3E()%2B1-A5)%2F(B5-A5%2B1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20format%20the%20end%20result%20as%20a%20percentage.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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 (New 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.