This is a case of my having figured something out, implemented it, and then forgotten what I did.
So I have a column of dates to which I add a row with a new date weekly. The first date in the list has been named "FirstDate." At the bottom of the column, there is a Total, and the formula is "LastDate-FirstDate." The problem is that I can't FIND what "LastDate" refers to. If I press Ctrl-G, "LastDate" is not listed, only "FirstDate." However, the formula is working! So clearly there's a LastDate. I've tried Trace Precedents, and it selects the entire column, but I still don't see "LastDate."
I'm trying to set up a similar sheet with a new set of dates, and the formula doesn't work.
Any suggestions would be appreciated!
Thanks.
Bookmarks