Date Progress Percentage not working

[Dee Slabbert]

Hello,

I am trying to use the formula (below) to automatically calculate the percentage of completion between two dates. I have tried multiple times but for some reason the formula does not work for my sheet.
Might it be because I'm using cells instead of columns that affect the formula?

Please help, I'm at my wits end!

Formula: =(DATEDIF(F11, TODAY(), "d")=1/(DATEDIF(F11, H11, "d")+1))

P.S. the dates are just for reference

 

[etaf]

that formula will give a TRUE or FALSE result
AND i Suspect only FALSE as you are trying to get the number of days to = the number of days divided into 1
but the formula as posted - does work for me, and NOT provide an error

try to avoid Merged cells

Book8
	A	B	C	D	E	F	G	H
1	FALSE			DateDif for F11	0
2				DateDif for H11	10
3				1/datedif	0.1
4
5
6
7
8
9
10
11						2/22/24		3/2/24
12
Sheet1

Cell Formulas
Range	Formula
A1	A1	=(DATEDIF(F11, TODAY(), "d")=1/(DATEDIF(F11, H11, "d")+1))
E1	E1	=DATEDIF(F11,TODAY(),"d")
E2	E2	=(DATEDIF(F11, H11, "d")+1)
E3	E3	=1/E2

 

[Georgiboy]

How about:

Book1
	E	F	G	H	I	J	K
10
11		21/02/2024		02/03/2024			Days Diff
12							10
13
14							% Days Passsed based on today
15							10%
Sheet1

Cell Formulas
Range	Formula
K12	K12	=H11-F11
K15	K15	=(TODAY()-F11)/(H11-F11)