How do I change from a 7 day week to a 5 day week in Excel?
There are a couple of functions that need the analysis toolpak addin installed
(tools|addins).
Look at help for
=workday()
and
=networkdays()
mozzer10 wrote:
I am trying to set up a deadline set up in Excel but it shouldnt include the
weekends, for instance I want events that shoudl be completed within 2 days
and that are started on friday to be shown to be completed on monday rather
than on saturday. how can I do this?
--
Dave Peterson
|