|
Build a calendar except weekends
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... |
Build a calendar except weekends
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... |
Build a calendar except weekends
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... |
Build a calendar except weekends
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... |
Build a calendar except weekends
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... |
| All times are GMT +1. The time now is 02:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com