I didn't notice that you were going back in time.

Put 12/18/2007 in A1
put 12/17/2007 in A2
and then do the rest of those instructions.

Dave Peterson wrote:

Another way:
Put 12/18/2007 in A1
Put 12/19/2007 in A2

Select A1:A2
right click on the autofill button on the bottom right corner of the selection
and drag down as far as you need.

When you let go of the rightmouse button, you'll be prompted with a bunch of
options. You can choose Fill Weekdays.

Nigel wrote:

I am trying to skip weekends from a date in a spreadsheet,

In Cell A1 I have todays date

In cell A2 A3 A4 A5 I need it to be the previous days date so based on
todays date
A2 would be 12-17, A3 tho would have to be 12-14, A4 would have to be 12-13
and so on

tomorrow tho

A2 would be 12-18 A3 would be 12-17 A4 should be 12-14 ...

what is the easiest way to accomplish this

thanks in advance

--

Dave Peterson

--

Dave Peterson