Hi there,

hopefully someone can help, the formula below is in cell AP81

=IF(AP54=AO54,IF(AP54=AN54,IF(AP54=AM54,IF(AP54=AL54,IF(AP54=AK54,IF(AP54=AJ54,Error,AP54+23),AP54+21),AP54+19),AP54+17),AP54+15),AP54+13)

What the formula does is look at the 6 cells to the left and if they are the
same (Dates) then makes the first cell +13 days, the next +15 days and so
on. If the dates in row 54 are different then the default +13 days happens,
which is how the formula is meant to work.

What i want the formula to do in AP81 is the following: IF cell AP80 is
greater than AP81 then AP80 + 2 days, else the formula above.

thanks in advance BigH