View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
 
Posts: 293
Default Using Row() and Today()

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