Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
6 Day Work Week?
I have been using a Workday function to create a schedule. Does anyone have
any suggestions on being able to create a 6 day work schedule. Maybe combine functions? Please advise. Thank you Jason Beckman |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
6 Day Work Week?
By "6 day work schedule" I presume you mean excluding Sundays. If you just
want to generate successive workdays then with your first date in A1 use this formula in A2 copied down as far as you need =IF(WEEKDAY(A1)=7,2,1)+A1 "jbeck068" wrote: I have been using a Workday function to create a schedule. Does anyone have any suggestions on being able to create a 6 day work schedule. Maybe combine functions? Please advise. Thank you Jason Beckman |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
6 Day Work Week?
-- ***** birds of the same feather flock together.. any suggestions on being able to create a 6 day work schedule. do you mean Monday to Saturday work,,Sunday no Work.... do you consider to exclude in your schedule the dates of holidays that fall on the workdays.. "jbeck068" wrote: I have been using a Workday function to create a schedule. Does anyone have any suggestions on being able to create a 6 day work schedule. Maybe combine functions? Please advise. Thank you Jason Beckman |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
6 day working
Hi Everybody,
am doing project for my process inwhich i need find the 10th day excluding sunday and holidays only not saturday. any suggestions please. EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrong Week number | Excel Worksheet Functions | |||
Calculating a colmun to total a 40 hour work week | Excel Worksheet Functions | |||
Calculating total work week hours | Excel Worksheet Functions | |||
how do I adjust working calendar (6 day work week) in excel that . | Excel Worksheet Functions | |||
How do I ensure dates inputted are during the work week? | Excel Worksheet Functions |