If Formula

[Ev1lZer0]

I have an If formula looking at a date in column J and comparing it to today's date so that I can get the total days between entered in column I

I am hoping to modify this a little bit to account for a different scenario

In column C I have another date called "outcome date."

If there is a dater in the column, I would like the formula to use this date instead of today's date.

please ignore Cell I2 and J2 - I am missing information that I need to manually enter. This formula is working fine - minus the change I'm asking for help on.

2022 Color Coded Watch List Copy.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	Date of Trial	Triage Date	TSO Date	Case Number	First Name	Last Name	NFC	In Custody	In Custody Date	Plea & Sentence	Competency Hearing	Pre-Trial	Readiness/Status	Continuances	Omnibus	Other Hearing Dates	Offer	Time Frame	Attorneys	NOTES	Order on Competency Evaluation	Outcome	Outcome Date	Color Code	Trailing
2	09/26/22	08/16/22	9/16/2022	22-1-00775-39 22-1-00285-39	Rusty	Garcia		#VALUE!	Fill			09/16/22						4 Days	Gill / West	Continued 9/26 - Witness/Victim avilability		Dismissed W/Prej	9/22/2022
3	10/03/22	08/22/22		16-1-02306-39 20-1-00183-39	Richard	Smith		1016	2/4/2020				10/10/22						Barrett / Smith	*Needs Triage set at status		Plea	11/1/2022	Red
2022 Trial Calendar

Cell Formulas
Range	Formula
I2:I3	I2	=IF($J2="","",DAYS($J2,TODAY())*-1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:C10000	Expression	=ISEVEN(MATCH($B2,UNIQUE(FILTER($B$2:$B$10000,$A$2:$A$10000=1)),0))	text	NO
B2:C10000	Expression	=ISODD(MATCH($B2,UNIQUE(FILTER($B$2:$B$10000,$A$2:$A$10000=1)),0))	text	NO
D2:Z10000	Expression	=$Y2="Pink"	text	NO
D2:Z10000	Expression	=$Y2="Yellow"	text	NO
D2:Z10000	Expression	=$Y2="Red"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
Y2:Y3	List	='Data Validation'!$A$2:$A$4
R2:R3	List	='Data Validation'!$C$2:$C$4
W2:W3	List	='Data Validation'!$B$2:$B$11

 

[ExceLoki]

try this

=IF($J2="","",DAYS($J2,IF(C2="",TODAY(),C2))*-1)