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

  • Thread starter Thread starter Naushad
  • Start date Start date
N

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.
 
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
 
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.
 
This doesn't seem to work.

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

formula result is Friday 3/13/09
 
This is an array formula which must be entered with CTRL+Shift+Enter and
NOT 'just enter.
 
Hi,
for the first Fri it works but for the second week onwards it does not take
Fri as weekend
 
Hi,

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

I have tried and all the suggestions given does not work. Please read my
requirement carefully, i have tried to elaborate more.
 
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.


++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 
Back
Top