Enter 1 in a cell.

Copy that cell.

Select the date cell.

Paste SpecialAddOKEsc.

Re-format as date.


Gord Dibben MS Excel MVP

On Fri, 13 Jul 2007 09:58:28 -0700, alex wrote:

Hello Experts,

I have an xls worksheet in which users paste a date from another
application.
Once pasted, I want to increase the value by one day (in the same
field).
Is that possible? And if so, how?

alex