Calculating two dates IF the cell contains content

[foxglove85]

I am not excel savy at all but I need help! Depending on if there is a date in the field, I need the results to populate in B3. I got two dates (difference between E9 and B9). But If there were to be a date in B12 (as opposed to B9) and a date in E9, can I get the result to populate in B3? Same with using E12 as opposed to E9...and either a start date in B8 or B12? There will only be two dates but it will depend on which start date cell is applicable and which end date cell is applicable. I hope this makes sense! Thank you!

 

[etaf]

how about
=DAYS(MAX(E9,E12),MAX(B9,B12))

Book1
	A	B	C	D	E	F
1
2
3		1
4
5
6
7
8
9		1/1/22			1/2/22
10
11
12		2/1/22			2/2/22
13
Sheet1

Cell Formulas
Range	Formula
B3	B3	=DAYS(MAX(E9,E12),MAX(B9,B12))