|
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 |
Using Row() and Today()
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. "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 |
Using Row() and Today()
Thank You sheeloo, getting better
"Sheeloo" wrote: 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. "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 |
Using Row() and Today()
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 |
Using Row() and Today()
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 |
| All times are GMT +1. The time now is 11:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com