ah_mktanlys_01
New Member
I am trying to use an equation that tracks the progress of a start and end date based on today's date.
I have used this before =
but my excel no longer has DATEDIF. I tried inputting the equation anyways and an error shows up.
I then used
to get the progress % and to account for if the date has not started yet. However, if I have a start and end date that is only 1 day, I need the equation to show 100% if the 1 day has occurred and 0% if the 1 date has not occurred.
I have used this before =
Code:
=MIN((DATEDIF(startdate,today(),"d")+1)/(DATEDIF(startdate,enddate,"d")+1)
I then used
Code:
=IF(startdate>TODAY(),0,MIN((TODAY()-startdate)/(enddate-startdate),100%))