View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eschroeter Eschroeter is offline
external usenet poster
 
Posts: 2
Default Date Change Macro

In Microsoft Money and Quicken, you have the ability to change the date up or
down by using the "+" and "-" keys. Does anyone know of a way to do that in
Excel? For instance, suppose you had a column of dates. I'm looking for a
way to arrow down this column and adjust each date accordingly by hitting the
plus or minus keys instead of manually retyping each date.