On Jul 13, 5:13 pm, Gord Dibben <gorddibbATshawDOTca wrote:
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- Hide quoted text -

- Show quoted text -

Thanks (to both) for your help. Your suggestions obviously worked.
Would you happen to know the VBA code to accomplish the same task,
without the extra step?
I'd like users to simply paste in the date and have said date
automatically increase by one.

alex