Friday as weekend instead of Saturday & Sunday
 

in a Workday function, Saturday & Sunday is taken as weekend. How can I make
Friday as weekend instead of Sat & Sun

Friday as weekend instead of Saturday & Sunday
 

Hi,

If you mean just Friday i.e. a single day as the weekend try this

=SUM(IF(ISERROR(MATCH(WEEKDAY(ROW(INDIRECT(A1&":"& B1))),{5},0)),1,0))

with your start date in a1 and end date in B1

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:

in a Workday function, Saturday & Sunday is taken as weekend. How can I make
Friday as weekend instead of Sat & Sun

Friday as weekend instead of Saturday & Sunday
 

oops,

Friday is 6 not 5

=SUM(IF(ISERROR(MATCH(WEEKDAY(ROW(INDIRECT(A1&":"& B1))),{6},0)),1,0))

Mike

"Mike H" wrote:

Hi,

If you mean just Friday i.e. a single day as the weekend try this

=SUM(IF(ISERROR(MATCH(WEEKDAY(ROW(INDIRECT(A1&":"& B1))),{5},0)),1,0))

with your start date in a1 and end date in B1

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:

in a Workday function, Saturday & Sunday is taken as weekend. How can I make
Friday as weekend instead of Sat & Sun

Friday as weekend instead of Saturday & Sunday
 

Hi,
What you have said it functions, but I want to find the end date if Start
date and number of days is given (with Friday only as weekend). Suppose
Thursday is the start date and number of days is 4 then End date should be
Monday (i.e. thu, Sat, Sun & Mon)

"Mike H" wrote:

Hi,

If you mean just Friday i.e. a single day as the weekend try this

=SUM(IF(ISERROR(MATCH(WEEKDAY(ROW(INDIRECT(A1&":"& B1))),{5},0)),1,0))

with your start date in a1 and end date in B1

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:

in a Workday function, Saturday & Sunday is taken as weekend. How can I make
Friday as weekend instead of Sat & Sun