MS Office 2007: To change working days

[akumarcom]

Hello All,

Currently I am working on a project and want to change its working days from Default Calendar.
For example in current calendar if we add a date which comes on Saturday/Sunday then system show the message and change the date the next day. Same, I want to make Friday and Saturday as a week-end days for non-working and system should show the same message and the date would be captured from next day.

I have tried many things but did not get success. Please suggest me some effective steps.
Awaiting your replies. Thanks,

 

[xlhelp]

Use of =Weekday(A2,2) should be able to resolve it; A2 being the date you are concerned with.


Avoid Hangovers. Stay drunk.