Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I adjust working calendar (6 day work week) in excel that .
I need to use the WORKDAY function, but adjust the working calendar to have
Friday and Saturday as the weekend, and in another case to work with 6 day work weeks. I cannot find anything in excel (as in MS Project) that lets me define the working calendar. |
#2
|
|||
|
|||
That is because Project is designed to work with schedules, Excel isn't. It
can't do everything (and should certainly not try to). Don't have an answer for the first one yet, but I'll keep trying, but the 6 day week can be solved with this formula that Frank Kabel posted just before Christmas =A1+IF(A2=0,0,SIGN(A2)*SMALL(IF((WEEKDAY(A1+SIGN(A 2)*(ROW(INDIRECT("1:"&ABS( A2)*10))),2)<7)*ISNA(MATCH(A1+SIGN(A2)*(ROW(INDIRE CT("1:"&ABS(A2)*10))),holi days,0)),ROW(INDIRECT("1:"&ABS(A2)*10))),ABS(A2))) where A1 is the start date, A2 is the duration, and you must have a range called holidays, even if there are no dates in it. -- HTH RP (remove nothere from the email address if mailing direct) "Hatem" wrote in message ... I need to use the WORKDAY function, but adjust the working calendar to have Friday and Saturday as the weekend, and in another case to work with 6 day work weeks. I cannot find anything in excel (as in MS Project) that lets me define the working calendar. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
Excel: Formula worked last week but now stoppped working. | Excel Worksheet Functions | |||
The colors should work properly in Shared Excel Workbooks. | Excel Worksheet Functions |