Found it !!!! thanks to Pearson consulting

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

pano wrote:
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