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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Friday as weekend in Workday Function 6
How to make Friday as weekend instead of Sat/Sun in Workday Functi 11
networkdays function 3
Workday function question 2
How do I set NETWORKDAYS to regard friday and saturday as weekend 2
Determining the Sunday date of the third "full" weekend of a month 25
How to calculate the number of Workdays for irregular work pattern 1
Calculate workdays for irregular work patterns 1

Back
Top