SOLVED

New Contributor

# Pourcentage Date

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)

Sincerly,

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

# Re: Pourcentage Date

@RSEdevelpper Why use DATEDIF in the first place?

Try this:

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

and format the end result as a percentage.

# Re: Pourcentage Date

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.

# Re: Pourcentage Date

@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.