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

"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.

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.

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.

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.

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.

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.

=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.

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.

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.

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.

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.