plus 1
enter 1 in a cell copy it
select the cell with the date
paste special add
this should increase the day by one, assuming what was pasted was a date and
not text that looked like a date.
"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
|