Changing weekday in workday formula

Closed
subbu - Feb 23, 2009 at 03:58 AM
nomadcrys Posts 195 Registration date Tuesday November 18, 2008 Status Member Last seen January 29, 2010 - Feb 23, 2009 at 04:13 AM
Hello,
When i am working in excel file i have troubled in work day calculations.May you help for getting a solution
in changing the weekday in workday(start date,no of days,holiday) formula.
For eg:
Start date: 02/02/2009
No of days to go:70
Holidays:05/02/2009

Formula tobe used:
workday(start date,no of days,holiday)

Here i want to change the default nonworking days(sat & sun to only wednesday)
regards
Subbu

1 response

nomadcrys Posts 195 Registration date Tuesday November 18, 2008 Status Member Last seen January 29, 2010 48
Feb 23, 2009 at 04:13 AM
I think you must format the cells and you click on number, Date and you choose your format.
0