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
|