Now I'm to the point where I need to get the average of all the
values... but those values which have not been listed are showing
31,000 days.

So, I did this to hide errors:

=IF(AVERAGE(E3:E29)180,"",AVERAGE(E3:E29))

But what I really want to do is average out the numbers which are
there, and ignore numbers greater than 180. I have three values I'm
averaging right now:
0
51
205

And its showing my average as being: <blank because its still
averaging the 31k days of the empty cells.

Any way to do this? Should I have the empty cells load a zero if the
days are greater than 180? Wouldn't that mess-up my real average?
Ugh... totally lost.