| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM (TODAY thru EOM) | Excel Discussion (Misc queries) | |||
| IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
| Today() | Excel Worksheet Functions | |||
| =today() | Excel Worksheet Functions | |||
|
=IF(OR(TODAY() |
Excel Discussion (Misc queries) | |||
Threaded Mode
