Update cell with various dates

kJohn985 

I'm (fairly) sure that what you're asking can be done, and (fairly) sure that it can be done fairly easily. 

HOWEVER, it's not altogether clear what you want to be done, or what the context is.

For example:

• given the date range of thirty years (!!!!; is that real?), what kind of reviews are we talking about?
• why are there only 42 reviews expected over that thirty year period?
• are they on a schedule?
• do you really want the number still needed to go down by one each time a new date is entered?
• what does the entry of a new date represent (given the thirty years)? 
• etc.

These are the kinds of questions we'd be reviewing if we were meeting face-to-face. You may think the answers are obvious (or that the questions are impertinent; "just tell me how to do it!")...but the design of a spreadsheet to accomplish desired results does, to a very great extent, depend on what those results are, how well the full process has been explained and understood.

So if you can humor me, I think others who might desire to help would appreciate a more complete description. If you can, without revealing any proprietary or confidential information, also post a copy of the actual spreadsheet, that would be helpful as well.