DATEDIF with two start dates

[tkroper]

Is there any way to compare one end date to two start dates, calculating whichever start date is later? For example:

[TABLE="width: 253"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Expiration Date[/TD]
[TD="align: right"]4/7/2018[/TD]
[/TR]
[TR]
[TD]Assignment Date[/TD]
[TD="align: right"]6/19/2018[/TD]
[/TR]
[TR]
[TD]Submission Date[/TD]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]142[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Expiration Date[/TD]
[TD="align: right"]4/7/2018[/TD]
[/TR]
[TR]
[TD]Assignment Date[/TD]
[TD="align: right"]3/5/2018[/TD]
[/TR]
[TR]
[TD]Submission Date[/TD]
[TD="align: right"]11/8/2018[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]215[/TD]
[/TR]
</tbody>[/TABLE]

 

[MARK858]

Please note that my dates are in dd/mm/yyyy format.

Excel Workbook
	A	B	C
1	Expiration Date	07/04/2018	07/04/2018
2	Assignment Date	19/06/2018	05/03/2018
3	Submission Date	08/11/2018	08/11/2018
4		142	215
Sheet303

 

[tkroper]

Of course! Why didn't I think of that? Thank you very much MARK858