How to display list of dates for the year excluding Sundays

[KitLam]

Hello,
I would like to use a formula to take the starting date in cell A1 and then have Excel give me a list of all the dates for 2009 excluding Sundays.

So A1 would be 1/01/09

Then Excel would list
Thursday, Jan 01
Friday, Jan 02
Saturday, Jan 03
Monday, Jan 05
Tuesday, Jan 06
etc....

I've tried messing with the WEEKDAY function, but can't seem to figure it out.

Thanks in advance for the help!

 

[Annatole]

In A2 (leaving A1 alone) enter a legit non-Sunday date.

Then, in A3 enter the formula =IF(A2="",A1+2,IF(WEEKDAY(A2)=7,"",A2+1))

Copy A3 as far down as needed.

This works great but how do I leave Saturday and Sunday blank?

 

[tusharm]

How does it leave Sunday blank? How would you extend that to include Saturday or Sunday?

This works great but how do I leave Saturday and Sunday blank?

 

[Annatole]

Hey,

I'm really not sure how it works but if I drag it down by the handle, it shows the dates for Monday through Sat, and leaves a blank cell for Sunday.

What I really want to do is be able to is have the dates from Monday to Friday, then leave a blank cell for Saturday and Sunday.

eg,

01/07/10
02/07/10
Blank Cell
Blank Cell
05/07/10
06/07/10
etc...

Thanks.