Friday as weekend in Workday Function
 

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

Friday as weekend in Workday Function
 

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

Fri & Sun, Fri & sat or just Friday

Mike

"Naushad" wrote:

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

Friday as weekend in Workday Function
 

On Sun, 8 Mar 2009 08:47:01 -0700, Naushad
wrote:

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

Friday as weekend in Workday Function
 

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?


"Naushad" wrote:

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

Friday as weekend in Workday Function
 

Look he

http://www.cpearson.com/excel/betternetworkdays.aspx


--
Kind regards,

Niek Otten
Microsoft MVP - Excel
"Naushad" wrote in message
...
How can i change weekend from saturday & Sunday to Friday for a workday
function

Friday as weekend in Workday Function
 

Hi,

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

"Sheeloo" wrote:

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?


"Naushad" wrote:

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

Friday as weekend in Workday Function
 

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.

"Niek Otten" wrote:

Look he

http://www.cpearson.com/excel/betternetworkdays.aspx


--
Kind regards,

Niek Otten
Microsoft MVP - Excel
"Naushad" wrote in message
...
How can i change weekend from saturday & Sunday to Friday for a workday
function