Well, I did last over a week...

My boss keeps changing requirements on me. Actually, I probably should have seen this issue coming.

Right now, the dates are listed as shown in Date1



I need what is shown in Date2



I've tried moving the columns, but that breaks the formula. I've tried moving the entire column, just the part that has data, but nothing works.

So, how do I move the columns? There's a 50/50 chance boss will want the due date as the first column of the spreadsheet (trying to talk him out of it), so please explain the process.

I've included the current spreadsheet (minus data), in case I screwed it up somewhere else.

thanks,


Jim

Attached Images

	Date1.png (6.4 KB, 57 views)
	Date2.png (4.5 KB, 55 views)

Attached Files

DueDate-test.xlsx (32.1 KB, 11 views)