Friday as weekend in Workday Function

N

Naushad

How can i change weekend from saturday & Sunday to Friday for a workday
function
 
M

Mike H

This isn't clear, what are the weekend days?

Fri & Sun, Fri & sat or just Friday

Mike
 
R

Ron Rosenfeld

How can i change weekend from saturday & Sunday to Friday for a workday
function
Click to expand...

What do you mean by that?

Is your weekend only Friday?
Friday and Saturday?
Friday, Saturday and Sunday?

--ron
 
S

Sheeloo

Instead of
=WORKDAY(A1,B1)
try
=WORKDAY(A1+1,B1)-1

where A1 contains the Start Date and B1 the Number of Days...

Not sure how this will work if you add Holidays and the holiday falls on Fri
or Sun...
Can you pl. test and let us know?
 
N

Naushad

Hi,

your solution takes Fri & Sat as weekends. If you can recheck and find
solution for Friday as weekend only. Thanks
 
N

Naushad

Hi,

it is a good site, but I couldn't find the solution of my problem. I need to
find the end date by adding number of days to a start date and taking only
Friday as weekly hoilday.
 

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

How to implement two shifts per day with multiple teams 0
Friday as weekend instead of Saturday & Sunday 3
Buffer between projects 1
Formula to tell day of week 3
How to make Friday as weekend instead of Sat/Sun in Workday Functi 11
Last workday 2
Calculate next workday after adding calendar days to date in cell 13
Workday function question 2

Top