Build a calendar except weekends

  • Thread starter Thread starter Guest
  • Start date Start date
G

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...
 
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
 
Thank you so much Sandy. It was very helpful.

Sandy Mann said:
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
Click to expand...
 
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
 
Back
Top