Workday Function - How to change to a 6 day workweek

[dgbear]

Excel 2002 seems to default to a 5 day workweek (Monday to Friday).

How do you change excel to base workday calculations on a 6 day work week (Monday to Saturday) ?

Thanks in advance,

DG

 

[counterscc]

Hello all: Here is what I am trying to do.
Lets say:
A1= 12/24/06
B1= A.Z.
Now I would like C1 to equal something like ( If B1 equals A.Z. then minus 8 days from A1, using a 6 day work week

Does that make any sense? Hope someone can help. Thanks

 

[fairwinds]

Barry's formula seems to work fine "backwards" so:

=IF(A2="A.Z.",INT(-8/6)*7+A1+MOD(-8,6)+INT((WEEKDAY(INT(-8/6)*7+A1)-2+MOD(-8,6))/6),"")

 

[barry houdini]

this is the best I could come up with - B1 should be bigger than 0

=INT(B1/6)*7+A1+MOD(B1,6)+INT((WEEKDAY(INT(B1/6)*7+A1)-2+MOD(B1,6))/6)

Just for the record - an improvement on the above formula - adds number of "business days" in B1 to date in A1 where "business days" are all days except Sundays. B1 can be negative or positive

=A1-WEEKDAY(A1,3)+INT(7/6*(B1+MIN(5,WEEKDAY(A1,3))))