Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel calendar - list of names displayed on calendar | Excel Worksheet Functions | |||
I wish to edit the calendar used in excel to exclude weekends | Excel Discussion (Misc queries) | |||
WEEKENDS VS. WEEKDAYS | Excel Discussion (Misc queries) | |||
WEEKENDS VS. WEEKDAYS | Excel Discussion (Misc queries) | |||
import calendar items from excel into outlook calendar | Excel Discussion (Misc queries) |