Excel - list days of a month, excluding Sundays

I need to put the dates of a month in a column each month (Jan, Feb, etc.),
but I do not want to list Sundays. Can this be done automatically or do I
just fill the series and delete the Sunday rows?

John Try:

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

with your start date in A1

--
HTH

Sandy
sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk


"John" <John@discussions.microsoft.com> wrote in message
news:8BD5F3A5-6609-4A5B-B23C-A00B6CA741FA@microsoft.com...
>I need to put the dates of a month in a column each month (Jan, Feb, etc.),
> but I do not want to list Sundays. Can this be done automatically or do I
> just fill the series and delete the Sunday rows?
>
>
>
>
>