How do I countdown the number of cells until an event in an adjacent column? I only want to look 7 days ahead.
<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...