Inserting dates in increments of X, based on dates in other cells

 I’m working with an old spreadsheet that has nearly 1500 rows of data.  This spreadsheet has been in existence since late 2009 and has been maintained by several different people, with no one providing Excel-minded, future-proofing leadership to unify what they were maintaining and how they were maintaining it.  As such, the data is incomplete and dirty.  Here’s how I fixed over 300 empty cells with estimated expiration dates within a few minutes (it can be done much quicker if you know exactly what you’re doing).

Advertisement