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


with @tiscali.co.uk


"Mary" wrote in message
...
Thank you so much Sandy. It was very helpful.

"Sandy Mann" wrote:

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


with @tiscali.co.uk


"Mary" wrote in message
...
List of dates

"Lauren Giles" wrote:

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

"Mary" wrote:

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...