Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Friday as weekend in Workday Function
How can i change weekend from saturday & Sunday to Friday for a workday
function |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set NETWORKDAYS to regard friday and saturday as weekend | Excel Worksheet Functions | |||
If weekend date display previous Friday date | Excel Discussion (Misc queries) | |||
Using WORKDAY function | Excel Worksheet Functions | |||
Workday function | Excel Discussion (Misc queries) | |||
If function for workday & weekend | Excel Worksheet Functions |