How do I countdown the number of cells until an event in an adjacent column? I only want to look 7 days ahead.
<tbody>
</tbody>
DATE | IRRIGATE (GALLONS) | DAYS UNTIL IRRIGATE |
1/1/2010 | -- | 4 |
1/2/2010 | -- | 3 |
1/3/2010 | -- | 2 |
1/4/2010 | -- | 1 |
1/5/2010 | 500 | 0 |
1/6/2010 | -- | 3 |
1/7/2010 | -- | 2 |
1/8/2010 | -- | 1 |
1/9/2010 | 520 | 0 |
1/10/2010 | -- | 3 |
1/11/2010 | -- | 2 |
1/12/2010 | -- | 1 |
1/13/2010 | 210 | 0 |
cont... |
<tbody>
</tbody>