Dates for month in cell a1 downwards

[pano]

Hello all
I want to be able to put a date in cell a1 - 1st Jan 2007 and then
have a2 downwards automatically fill in the dates of the month
excluding the saturdays and sundays???

Any helpers with this

thanks

 

[pano]

Found it !!!! thanks to Pearson consulting

=IF(WEEKDAY(A4)=7,A4+2,IF(WEEKDAY(A4)=6,A4+3,A4+1))

 

[Guest]

Assuming you always put the first workday of the month in A1 then you can use
this formula in A2 copied down to A23 to give all weekdays in the month

=IF(A1="","",IF(MONTH(WORKDAY(A1,1))<>MONTH(A1),"",WORKDAY(A1,1)))

note:

WORKDAY is part of Analysis ToolPak add-in

 

[Guest]

Fill in the first 2 days and then select your range including the 2 days you
typed and try Edit - Fill - Series - weekdays and this may do the trick.

 

[pano]

Hmm cant use the analysis Toolpak addin, this is a work toughbook and
it is LOCKED down to billy oh by the IT Dept

 

[Bob Phillips]

In A2

=IF(A1="","",IF(WEEKDAY(A1+1,2)<6,IF(MONTH(A1+1)=MONTH($A$1),A1+1,""),IF(MON
TH(A1+3)=MONTH($A$1),A1+3,"")))

copy down.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[pano]

Thanks Bob that does the trick

In A2

=IF(A1="","",IF(WEEKDAY(A1+1,2)<6,IF(MONTH(A1+1)=MONTH($A$1),A1+1,""),IF(MO­N
TH(A1+3)=MONTH($A$1),A1+3,"")))

copy down.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Dave Peterson]

Mike's suggestion doesn't use the Analysis toolpak.