Thanks Bob that does the trick


On Jan 29, 10:00 pm, "Bob Phillips" wrote:
In A2

=IF(A1="","",IF(WEEKDAY(A1+1,2)<6,IF(MONTH(A1+1)=M ONTH($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)

"pano" wrote in glegroups.com...



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- Hide quoted text -- Show quoted text -