Using Row() and Today()

S

stew

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
 
S

Sheeloo

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.
 
S

stew

Thank You sheeloo, getting better

Sheeloo said:
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.
Click to expand...
 
S

ShaneDevenshire

Hi,

I think this is what you want to do:

=$A$2+IF($A$2>=TODAY(),ROW()/113)

or

=$A$2+IF($A$2<=TODAY(),ROW()/113)

This increments the date by 1 on row 113 and 226, 339....

Its not clear if you are trying to increment every 113 days or every 100
days starting at row 113. If you are trying to do the latter then

=$A$2+IF($A$2>=TODAY(),(ROW(A1)-1)/100)

or

=$A$2+IF($A$2<=TODAY(),(ROW(A1)-1)/100)

If this helps, please click the Yes button.
 
Top