Build a calendar except weekends

[Guest]

Hi,
Can you please help me? Is there any formula to build a calendar excluding
weekends?
Example:
Date
Thursday March 01, 2007
Friday March 02, 2007
Monday March 05, 2007
Tuesday March 06, 2007
Wednesday March 07, 2007
Thursday March 08, 2007
Friday March 09, 2007
Monday March 12, 2007
Tuesday March 13, 2007
Wednesday March 14, 2007
Thursday March 15, 2007
Friday March 16, 2007
etc...

 

[Guest]

How do you want the calandar to look? Just a square calandar? Or a list of
dates?

 

[Guest]

List of dates

How do you want the calandar to look? Just a square calandar? Or a list of
dates?

 

[Sandy Mann]

With the start date in A1 try:

=IF(WEEKDAY(A1+1,2)>5,A1+3,A1+1)

or

=A1+1+(WEEKDAY(A1,2)=5)*2

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

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

 

[Guest]

Thank you so much Sandy. It was very helpful.

With the start date in A1 try:

=IF(WEEKDAY(A1+1,2)>5,A1+3,A1+1)

or

=A1+1+(WEEKDAY(A1,2)=5)*2

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

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

 

[Sandy Mann]

You are very welcome Mary, I'm glad that it helped.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

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