How do I change from a 7 day week to a 5 day week in Excel?
 

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?

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