Hi there
I have a column of dates in col A e.g.
23/5/13
23/5/13
24/5/13
27/5/13
3/6/13
etc
I need to create a column in column B that has the same dates but all incremented by 1 day
24/5/13
24/5/13
25/5/13
28/5/13
4/6/13
Column A part of a table that is filtered so not all the rows are visible
I can do this if I select each cell and drag the + in the lower right into column B while holding down control key
But I have hundreads of dates in column A
Can anyone help?
Cheers
Jonj
Bookmarks