How to make Friday as weekend instead of Sat/Sun in Workday Functi

[Naushad]

if in cell A1 is the no.of days and in cell B1 is the start date. How can I
have workday calculated in cell c1 with Friday as weekend and saturdays &
sundays as workdays.

 

[Mike H]

Is this a different question?

=(A1+B1)+SUM(IF(WEEKDAY(B1-1+ROW(INDIRECT("1:"&TRUNC((B1+A1)-B1)+1)))=6,1,0))

This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array


Mike

 

[Fred Smith]

You've asked this question three times, and have responses to each one. It's
no use posting again until you read the responses, and respond to them as
needed.

Regards,
Fred.

 

[alstubna]

This doesn't seem to work.

# of days 1
start date of 3/12/09 -Thursday

formula result is Friday 3/13/09

 

[Teethless mama]

=A1+B1+SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1+B1&":"&B1)))=6))

Normally ENTER

 

[Teethless mama]

This is an array formula which must be entered with CTRL+Shift+Enter and
NOT 'just enter.

 

[Shane Devenshire]

Try

=(MOD(B1+A1,7)=6)+B1+A1

 

[Naushad]

Hi,
for the first Fri it works but for the second week onwards it does not take
Fri as weekend

 

[Naushad]

hi,
for the first Friday it works but not for second and other fridays

 

[Naushad]

Hi,

It takes Fri as weekend but 2 working days is counted once for saturday.
Please try to correct the error.
thanks

 

[Naushad]

Hi,

I have tried and all the suggestions given does not work. Please read my
requirement carefully, i have tried to elaborate more.

 

[HARSHAWARDHAN. S .SHASTRI]

Dear Naushad ,

I have tried following formula and it works as per your need.

=A1+B1+INT((B1+A1-6)/6)-INT((B1-6)/6)

H S Shastri


Pl press YES if found useful.


++++++++++++++++++++++++++++++++++++++++++++++++++++++++