Inside Microsoft Excel

Adjust your active cell’s date with the click of a button

Inside Microsoft Excel

by Stephen Nebel

This article has two goals. First, we’ll give you the ability to bump Excel date values up or down without actually having to edit them. Second, we’ll develop a model for small, easily portable utilities in Excel 2000-2013. Let’s take a look at the date manipulation goal first.

Manipulate dates without manual editing

I’ve got a couple of spreadsheets where I periodically copy forward rows containing dates, then update the date values. The date[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)