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

M

mozzer10

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?
 
D

Dave Peterson

There are a couple of functions that need the analysis toolpak addin installed
(tools|addins).

Look at help for
=workday()
and
=networkdays()
 
Top