Excel - list days of a month, excluding Sundays

G

Guest

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?
 
S

Sandy Mann

John Try:

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

with your start date in A1

--
HTH

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I get no of Sundays and working days of the month? 6
Working Days excluding Sundays 6
Counting calendar Days - not including Sundays 3
adding days from one cell with a date in it to another cell 3
No Sat & Sundays 2
Calculating dates to include Saturdays but not Sundays 1
days in month - Ajit 11
dates of month automation 3

Top