How do you stop the clock???
Cell 1 Today () function
Cell 2 Beginning Date
Cell 3 End Date
The above are IMPUT DATA CELLS
Cell 4 Results # days between cell 2 & 3
Cell 5 Counts down the # of days left from the amount in cell 4
Now this all works perfectly, however, when cell 5 gets to "0" it continues to count all subsequent days as negative days ie. -1 -2 -3 etc. HOW DO YOU STOP THE CLOCK AT zero days left??
Thank You, Gene Gould OD
Cell 1 Today () function
Cell 2 Beginning Date
Cell 3 End Date
The above are IMPUT DATA CELLS
Cell 4 Results # days between cell 2 & 3
Cell 5 Counts down the # of days left from the amount in cell 4
Now this all works perfectly, however, when cell 5 gets to "0" it continues to count all subsequent days as negative days ie. -1 -2 -3 etc. HOW DO YOU STOP THE CLOCK AT zero days left??
Thank You, Gene Gould OD