Yes, I can See this would do the Job too.

Thanks for coming to my aid

stewart

"ShaneDevenshire" wrote:

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.
--
Thanks,
Shane Devenshire


"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