Select last date from three cells and leave blank if no dates entered

[SaraWitch]

Hi peeps.

I have three sets of dates - start date and end date - and I want to show only the last end date in a separate cell.

For example:
First dates - start date B1, end date C1
Second dates - start date E1, end date F1
Third dates - start date H1, end date I1
Last end date - A1

I don't want to show C1 end date if there is a date in F1, and I don't want to show C1 or F1 end dates if there is a date in I1. And I want a blank cell in A1 (formula) if no dates are in C1, F1 and I1.

I'm nearly there with a formula (see below), which is working for dates in I1 and F1 but not C1. I have tried several variations but nothing is working.

=IF(I1>0,I1,IF(I1="",F1,IF(F1="",C1,IF(C1>0,C1,""))))

Any help would be muchly appreciated...

 

[DanteAmor]

Try

=IF(COUNTA(C1:C3)=0,"",MAX(C1:C3))

 

[SaraWitch]

Just perfect! Thank you, @DanteAmor!

 

[SaraWitch]

I've just realised that there was an additional element to what I needed, i.e., not to show an end date if a further start date was added.

So, just in case it's useful for anyone else, I added a cell to have a start date (A1) and then had my overall end date in B1. My other start and end dates followed and this formula works for me:

=IF(A1="","",IF(G1>0,H1,IF(E1>0,F1,IF(C1>0,D1))))