How To Make Cell Blank If Two Other Cells Are Not Populated With Dates

[Consult123]

I have a formula that automatically calculates the percentage of completion on a project between two dates (the start date and end date). The formula I chose to use is: =IFERROR(MIN((DATEDIF(D11,TODAY(),"d")+1)/(DATEDIF(D11,E11,"d")+1),100%),0). However, when column D and E are not populated Column L shows 100% complete. How do I make Column L blank if Column D and E are not both populated?

 

[awoohaw]

I am not ratifying your formula. But wrap it in an AND function:
(you don't really need DATEDIF for days).

=IF(AND(d11 = "", e11="","",IFERROR(MIN((DATEDIF(D11,TODAY(),"d")+1)/(DATEDIF(D11,E11,"d")+1),100%),0))

again, please use the xl2bb add in. I(link below, i mentioned this in your other question).

 

[Consult123]

I am not ratifying your formula. But wrap it in an AND function:
(you don't really need DATEDIF for days).

=IF(AND(d11 = "", e11="","",IFERROR(MIN((DATEDIF(D11,TODAY(),"d")+1)/(DATEDIF(D11,E11,"d")+1),100%),0))

again, please use the xl2bb add in. I(link below, i mentioned this in your other question).

I don't understand your response but did get xl2bb to work after a bit of struggling. Please see below

Goals List Creation.xlsx
	A	B		D	E	F	G					L
3	Task ID	Task Name		Start Date	Due Date	Actual % Complete	Status					Progress Tracker
4	TASK-001	Support new user acquisition in targeted regions		12/29/23	12/1/2024	1%	IN PROGRESS					1%
5	TASK-002	Improve customer satisfaction and reduce churn		10/02/23	1/2/2024	5%	OFF TRACK					97%
6	TASK-003	Bolster revenue from new products and services		12/03/23	12/3/2024	1%	ON TRACK					8%
7	TASK-004	Increase upsell and cross-sell revenue from existing customers		01/04/23	12/4/2024	50%	AT RISK					51%
8	Q2	2024
9	Task ID	Task Name		Start Date	Due Date		Status					Progress Tracker
10	TASK-004	Ramp up talent acquisition to strengthen teams		12/30/2023	12/30/2023	100%	COMPLETE					100%
11	TASK-005	Cultivate a customer community					CANCELLED					100%
12	TASK-006	Increase employee productivity through automation		1/3/2024	12/3/2024	0%	NOT STARTED					0%
2024

Cell Formulas
Range	Formula
L10:L12,L4:L7	L4	=IFERROR(MIN((DATEDIF(D4,TODAY(),"d")+1)/(DATEDIF(D4,E4,"d")+1),100%),0)

 

[Consult123]

I am not ratifying your formula. But wrap it in an AND function:
(you don't really need DATEDIF for days).

=IF(AND(d11 = "", e11="","",IFERROR(MIN((DATEDIF(D11,TODAY(),"d")+1)/(DATEDIF(D11,E11,"d")+1),100%),0))

again, please use the xl2bb add in. I(link below, i mentioned this in your other question).

I get the following error with your formula

 

[awoohaw]

=IF(AND(d11 = "", e11=""),"",IFERROR(MIN((DATEDIF(D11,TODAY(),"d")+1)/(DATEDIF(D11,E11,"d")+1),100%),0))

but, I think a better formula is in Post #9 of the other thread. Here it is again:

=IF(D11="","",IF(D11>Today(),0,(Today()-D11+1)/(E11-D11+1)))