Exclude Weekends in Autofill

[PSelman]

Is it possible to do this?

Or is there a quick way of filling all Monday to Friday's for entire year and excluding weekend days?

Thanks

 

[fairwinds]

Hi,

Try:

A1: First date

A2: =WORKDAY(A1,1)

drag down.

 

[PSelman]

Thanks.....but I can't seem to make that work.

I want to have a list of all Mon-Fri dates in 2005 and exclude the Sat/Sun in between them

I have put 3/1/5 in A2 (my first cell) and the formula in A3 as

=WORKDAY(A2,1)

but it comes back as #REF

 

[fairwinds]

Analysis toolpack must be enabled. Is it? (Toosl - Add-ins...)

Book1
	A	B	C	D
1
2	2005-01-03
3	2005-01-04
4	2005-01-05
5	2005-01-06
6	2005-01-07
7	2005-01-10
8	2005-01-11
9	2005-01-12
10	2005-01-13
11	2005-01-14
12	2005-01-17
13	2005-01-18
14	2005-01-19
Sheet9

 

[PSelman]

Cracked it

Much appreciated

 

[Domski]

Alright fella,

There's a little known (to anyone I know) hidden menu that can cope with this.

Type 3/1/2005 in cell A1 and then RIGHT click in the botton right hand corner of the cell.

Drag the mouse down a few cells and release the mouse button in the same way as you do a fill with the left mouse button pressed.

A menu will pop up asking you what sort of fill series you would like.

This works with dates, days, numbers and probably other things that I haven't discovered yet.

Enjoy!!!

 

[dirtyfrog]

Wow Dom, that's great! Never seen that before, or read anything about it, looks like it could be very useful

 

[fairwinds]

Yes, Great call Dom. Should have thougt of that.