Increment a cell

  • Thread starter Thread starter Stan Brown
  • Start date Start date
S

Stan Brown

I have a date in a cell (constant, not the result of a formula).

Is there any keyboard shortcut that will add 1 to the date, or do I
need to write a little macro?

Example: cell contains 2007-12-14; pressing the key combination
should change it to 2007-12-15.

(I tried "increment" in Excel help but didn't get anything useful.
Maybe I need a different search term?)
 
Hi Stan.........
There's nothing that I know of to do what you want, short of a macro. Of
course Ctrl-semicolon will give you the hard current date, if that is what
you're after.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top