Pourcentage Date

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.



3 Replies
best response confirmed by RSEdevelpper (New Contributor)

@RSEdevelpper Why use DATEDIF in the first place?


Try this:



and format the end result as a percentage.

Thank you for the answer, i first used this website :
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.