Hi there,

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

=IF(AP54=AO54,IF(AP54=AN54,IF(AP54=AM54,IF(AP54=AL 54,IF(AP54=AK54,IF(AP54=AJ54,Error,AP54+23),AP54+2 1),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


--
BigH
------------------------------------------------------------------------
BigH's Profile: http://www.excelforum.com/member.php...o&userid=34410
View this thread: http://www.excelforum.com/showthread...hreadid=541952