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

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.

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

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

"Naushad" wrote:

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.

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

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.

"Naushad" wrote in message
...
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.

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

This doesn't seem to work.

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

formula result is Friday 3/13/09


"Mike H" wrote:

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

"Naushad" wrote:

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.

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

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

Normally ENTER


"Naushad" wrote:

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.

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

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


"alstubna" wrote:

This doesn't seem to work.

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

formula result is Friday 3/13/09


"Mike H" wrote:

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

"Naushad" wrote:

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.

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

Try

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Naushad" wrote:

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.

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

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

"Mike H" wrote:

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

"Naushad" wrote:

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.

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

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

"Teethless mama" wrote:

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

Normally ENTER


"Naushad" wrote:

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.

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

Hi,

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

"Shane Devenshire" wrote:

Try

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Naushad" wrote:

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.

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

Hi,

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

"Fred Smith" wrote:

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.

"Naushad" wrote in message
...
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.

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

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.


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

"Naushad" wrote:

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.