Pls Try this:

=IF(LEN(A1)=0,"",IF(MOD(A1,7)=0,IF(DAY(A1)<DATE(20 08,MONTH($A$1)+1,1)-DATE(2008,MONTH($A$1),1)-1,A1+2,""),IF(DAY(A1)<DATE(2008,MONTH($A$1)+1,1)-DATE(2008,MONTH($A$1),1),A1+1,"")))

It will work for all months..
--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast


"John C" wrote:

What value do you get in A26?
--
** John C **


"Duke Carey" wrote:

To skip Sundays: with 11/1/08 in A1, enter this in A2 and copy down

=IF(WEEKDAY(A1)<7,1,2)+A1


"Amber" wrote:

I want to fill a series of dates, for example cell A1 = November 1, 2008
through cell A30 = November 30, 2008. BUT I do not want to include any
Sundays, so A1 = Saturday 11/1, cell A2 = Monday 11/3, etc. I also want to
only fill one month, so if the end of the list goes to December, that would
be excluded also. (I think I figured that one out but if it conflicts I will
need help) Thank you so much.