@MO-38
So it sounds like you are tracking the history of something or other. It could be helpful if you could post a copy of the full spreadsheet.
That said, I personally would recommend modifying the way you track the history.
- Right now you have three columns: a single column that names the stage "In Progress" or "Done" and two columns with the dates of those two stages respectively,
- Consider having just two columns, with the headings on the columns being "In Progress" and "Done" and then enter the dates that are applicable.
- Or--and this would be more of a way to keep historical records in general--have a new row for each stage, with the date being the first column, and the rest of the row being stage specific details. This will enable you to add (as needed) stages beyond "In Progress" and "Done" to include such things as "Revised" "Defunct"....whatever. I'm just pointing out the possibilities. Depending on what it is you're tracking, you could also include names of people or places, other important things that may or may not be important.
Are you amenable to re-thinking the process along lines like that? You'd be creating (I believe) a more robust database in the process, offering a lot more in the way of meaning and value.
