Oct 26 2021 01:37 AM
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,
Oct 26 2021 02:19 AM
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.
Oct 26 2021 04:32 AM
Oct 26 2021 04:44 AM
@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.
Oct 26 2021 02:19 AM
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.