Thank You sheeloo, getting better

"Sheeloo" wrote:

Change = to < or swap the outcomes...
You have written the result you want on the FALSE outcome of IF condition.

Use
=IF($A$2<(TODAY()),$A$2,($A$2+SUM(ROW()-10)/113))

or

=IF($A$2=(TODAY()),($A$2+SUM(ROW()-10)/113),$A$2)

If both are giving you problem then make sure that A2 contains a valid
date... You can test by putting =today() + 1 in A2.



"stew" wrote:

Hi all

On the list below from row 10 i am using the following
=IF($A$2=(TODAY()),$A$2,($A$2+SUM(ROW()-10)/113))

ThE INTENTION BEING TO TRIP +1 ON THE DATE ON CELL A113 IF a2 is greater
than or equal to todays date

WHAT HAVE I DONE WRONG



A
25.10.2008 ROW 2
Tour Start Date ROW 3






25.10.2008 ROW 10
25.10.2008
25.10.2008
25.10.2008
25.10.2008
25.10.2008
25.10.2008
25.10.2008
25.10.2008
25.10.2008
25.10.2008
25.10.2008 row113
25.10.2008
25.10.2008