Friday as weekend instead of Saturday & Sunday

[Naushad]

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

 

[Mike H]

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

 

[Mike H]

oops,

Friday is 6 not 5

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

Mike

 

[Naushad]

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)