Adding 2 days to the greater of three dates

[Maddoktor]

Hi all,

I am hoping someone can help me with the following problem.

Columns A,B, and C have three different dates in them (i.e. Column A -
23/02/05, column B - 21/02/05 and column C - 22/02/05). I would like a
formula to add two days to the greater date (i.e. column A) and therefore
column D should equal 25/02/05.

I thank you all in advance.

Regards

Mas

 

[Niek Otten]

Hi Mas,

=MAX(A1:C1)+2

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Maddoktor]

Thanx Niek,

It worked great.

Ciao
Maddoktor

Hi Mas,

=MAX(A1:C1)+2

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel