N
Naushad
How can i change weekend from saturday & Sunday to Friday for a workday
function
function
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
This isn't clear, what are the weekend days?
Fri & Sun, Fri & sat or just Friday
Mike
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
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?
=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
Niek Otten
N
Naushad
Hi,
your solution takes Fri & Sat as weekends. If you can recheck and find
solution for Friday as weekend only. Thanks
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.
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.