Friday as weekend instead of Saturday & Sunday

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

Naushad

in a Workday function, Saturday & Sunday is taken as weekend. How can I make
Friday as weekend instead of Sat & Sun
 
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
 
oops,

Friday is 6 not 5

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

Mike
 
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)
 
Back
Top